Reports2017-11-18T12:27:27+00:00

AP Payables Lookup Listing - draft

Description
Categories: BI Publisher, Financials, Procurement
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 Name SQL text Validation
Ledger
 
Effective Date
 
Date
Include Active/Inactive Codes
 
LOV Oracle
Sort QuickCodes By
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept