CST Overhead

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Overhead Report
Application: Bills of Material
Source: Overhead Report (XML)
Short Name: CSTROVHD_XML
DB package: BOM_CSTROVHD_XMLP_PKG
Run CST Overhead and other Oracle EBS reports with Blitz Report™ on our demo environment
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