AP Distribution Set Listing - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Distribution Set Listing (XML) - Not Supported: Reserved For Future Use
Short Name: APXGDGDL_XML
DB package: AP_APXGDGDL_XMLP_PKG
            SELECT  apds.distribution_set_id C_DIST_SET_ID,
                distribution_set_name    C_DIST_SET_NAME,
                apds.description         C_DDESCRIPTION,
                inactive_date            C_INACTIVE_DATE,
                    distribution_set_line_number
                                             C_DIST_SET_LINE_NUM,
                apdsl.description        C_ADESCRIPTION,
                    null              C_FLEXDATA,
                percent_distribution     C_PERCENT,
                type_1099                C_A1099,
                    vat_code                 C_TAX,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD
            FROM    ap_distribution_sets apds, ap_distribution_set_lines apdsl,
                gl_code_combinations gc
            WHERE   (apds.distribution_set_id
                = apdsl.distribution_set_id)
                AND
                (code_combination_id = dist_code_combination_id)
                AND
                (DECODE(Upper(:P_whichset),'ACTIVE',
                nvl(inactive_date, (trunc(:P_effective_date)) +1) -
                trunc(:P_effective_date),
                'INACTIVE',(trunc(:P_effective_date)) - nvl(inactive_date,
                (trunc(:P_effective_date)) +1),
                'BOTH',1,NULL,1) > 0)
            ORDER BY    distribution_set_name, distribution_set_line_number
Parameter Name SQL text Validation
Ledger
 
Effective Date
 
Date
Include Active/Inactive Sets?
 
LOV Oracle
Ask a question