CST Overhead
Description
- Categories
- BI Publisher
- Application
- Bills of Material
- Source
- Overhead Report (XML)
- Short Name
- CSTROVHD_XML
- DB package
- BOM_CSTROVHD_XMLP_PKG
Imported from BI Publisher
Overhead Report
Overhead Report
SQL 22 lines
SELECT lu.meaning ovhtype , br.resource_code resource_code , br.description description , lu2.meaning basis , ca.activity activity , &P_FLEXDATA absorption_acct_raw , br.disable_date, fnd_flex_xml_publisher_apis.process_kff_combination_1('absorption_acct_seg', 'SQLGL', 'GL#', GL.CHART_OF_ACCOUNTS_ID, NULL, GL.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') absorption_acct_seg FROM mfg_lookups lu , mfg_lookups lu2 , gl_code_combinations gl , cst_activities ca , bom_resources br WHERE lu.lookup_type = 'CST_COST_CODE_TYPE' AND lu.lookup_code in (2,5) AND lu.lookup_code = br.cost_code_type AND br.organization_id = :organization_id AND br.default_basis_type = lu2.lookup_code AND lu2.lookup_type = 'CST_BASIS_SHORT' AND ca.activity_id (+) = br.default_activity_id AND gl.code_combination_id (+) = br.absorption_account |