AP Distribution Set Listing- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Distribution Set Listing
Application: Payables
Source: Distribution Set Listing (XML) - Not Supported: Reserved For Future Use
Short Name: APXGDGDL_XML
DB package: AP_APXGDGDL_XMLP_PKG
Run AP Distribution Set Listing- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
            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
Operating Unit 
 
 LOV
Include Active/Inactive Sets? 
 
 LOV Oracle
Effective Date 
 
 Date
Download
Related Blitz Reports
ECC Procurement, Requisitions CST AP and PO Accrual Reconciliation CST Miscellaneous Accrual Reconciliation PO Headers and Lines PO Endeca Template XXT OF: PO Headers and Lines PN Billing/Payment Upload XXSUB PO Headers and Lines AP Supplier Upload
Blitz Report™

Blitz Report™ provides multiple benefits: