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
Run AP Payables Lookup Listing- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
            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 Name SQL text Validation
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 CST AP and PO Accrual Reconciliation AP Matching Hold Detail Report- Not Supported: Reserved For Future Use ECC Procurement, Purchase Order Metrics JL Argentine Payables Withholding Certificate - draft JA India - Open Transactions Report for Prior-GST (XML Publisher) PO Matching Holds Report by Buyer PO Blanket and Planned PO Status PO Receiving Transactions Pipeline JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: