INV Account alias listing
Description
- Categories
- BI Publisher
- Application
- Inventory
- Source
- Account alias listing (XML)
- Short Name
- INVSRAAL_XML
- DB package
- INV_INVSRAAL_XMLP_PKG
Imported from BI Publisher
Account alias listing
Account alias listing
SQL 20 lines
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 |