AP Payables Lookup Listing- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Payables Lookup Listing
Application: Payables
Source: Payables Lookup Listing (XML) - Not Supported: Reserved For Future Use
Short Name: APXQCQCL_XML
DB package: AP_APXQCQCL_XMLP_PKG
            SELECT  lc2.displayed_field C_PRODUCT,
                    DECODE (:p_sort_option,'Type,QuickCode',
                        lc.lookup_type , 'No order column') C_SORT_1,
                    UPPER(lc.lookup_code) C_SORT_2,
                    lc.lookup_code C_LOOKUP_CODE,
                    lc.lookup_type C_LOOKUP_TYPE,
                    lc.displayed_field C_DISPLAYED_FIELD,
                    lc.description C_DESCRIPTION,
                    lc.inactive_date C_INACTIVE_DATE
            FROM    ap_lookup_codes lc, ap_lookup_codes lc2,
                    ap_lookup_types lt
                WHERE   DECODE(Upper(:p_active_type),'ACTIVE',
                    nvl(lc.inactive_date, :lp_effective_date
                            + 1) - :lp_effective_date,
                    'INACTIVE', :lp_effective_date +1 -
                            nvl(lc.inactive_date, :lp_effective_date
                            + 1), 'BOTH',1,
                    NULL,1) > 0
                AND    lc2.lookup_type = 'PRODUCT_NAMES'
                AND    lc2.lookup_code = 'AP'
                AND    lc.lookup_type = lt.lookup_type
                AND    lt.user_updatable_flag = 'Y'
                UNION
            SELECT  lc2.displayed_field C_PRODUCT,
                    DECODE (:p_sort_option,'Type,QuickCode',
                        lc.lookup_type , 'No order column') C_SORT_1,
                    UPPER(lc.lookup_code) C_SORT_2,
                    lc.lookup_code C_LOOKUP_CODE,
                    lc.lookup_type C_LOOKUP_TYPE,
                    lc.displayed_field C_DISPLAYED_FIELD,
                    lc.description C_DESCRIPTION,
                    lc.inactive_date C_INACTIVE_DATE
            FROM    po_lookup_codes lc, ap_lookup_codes lc2,
                    po_lookup_types lt
                WHERE   DECODE(Upper(:p_active_type),'ACTIVE',
                    nvl(lc.inactive_date, :lp_effective_date
                            + 1) - :lp_effective_date,
                    'INACTIVE', :lp_effective_date +1 -
                            nvl(lc.inactive_date, :lp_effective_date
                            + 1), 'BOTH',1, NULL,1) > 0
                AND    lc2.lookup_type = 'PRODUCT_NAMES'
                AND    lc2.lookup_code = 'PO'
                AND    lc.lookup_type = lt.lookup_type
                AND    lt.user_updatable_flag = 'U'
                ORDER BY    1, 2, 3, 4, 5, 6, 7
Parameter NameSQL textValidation
Operating Unit
 
LOV
Sort QuickCodes By
 
LOV Oracle
Include Active/Inactive Codes
 
LOV Oracle
Effective Date
 
Date
Download
Related Blitz Reports
ECC Procurement, Purchase Orders JL Argentine Payables Withholding Certificate - draft JA India - Open Transactions Report for Prior-GST (XML Publisher) AP Invoices and Lines PO Matching Holds Report by Buyer PO Blanket and Planned PO Status AP Invoice Upload PO Receiving Transactions Pipeline TMEIC Purchase Register JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use
Blitz Report™