INV Account alias listing

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Account alias listing
Application: Inventory
Source: Account alias listing (XML)
Short Name: INVSRAAL_XML
DB package: INV_INVSRAAL_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT 
    mdsp.disposition_id                  mdsp_id, 
   null               account_alias, 
    mdsp.description                      description,
    mdsp.distribution_account      dist_acct_id, 
   null                     gl_account,
    mdsp.effective_date                  effective_date,
    mdsp.disable_date                    disable_date, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_mdsp_value', 'INV', 'MDSP', 101, MDSP.ORGANIZATION_ID, MDSP.DISPOSITION_ID, 'ALL', 'Y', 'VALUE') C_mdsp_value, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_dist_acct_value', 'SQLGL', 'GL#', GLCC.CHART_OF_ACCOUNTS_ID, NULL, GLCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_dist_acct_value
FROM 
   MTL_GENERIC_DISPOSITIONS    mdsp,
   GL_CODE_COMBINATIONS        glcc
WHERE 
   mdsp.distribution_account  = glcc.code_combination_id (+)
and 
   mdsp.organization_id =  :P_ORGANIZATION_ID 
 order by 
&P_MDSP_ORDER_BY