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
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 |