INV Account alias listing

➜ Back to Library
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
Run INV Account alias listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
CST Periodic Material and Receiving Distribution Details INV Lot transaction register INV Serial number transaction register INV Serial number detail INV Material Transactions GL Account Analysis (Distributions) INV Item Supply/Demand INV Item reservations GL Account Analysis INV Transaction Register
Blitz Report™

Blitz Report™ provides multiple benefits: