View: CST_AVG_DIST_ACCTS_V

Product:	BOM - Bills of Material
Description:	Default general ledger accounts by cost group
Implementation/DBA Data:	APPS.CST_AVG_DIST_ACCTS_V

View Text

SELECT CGA.ORGANIZATION_ID
, CGA.COST_GROUP_ID
, CGA.MATERIAL_ACCOUNT
, CGA.MATERIAL_OVERHEAD_ACCOUNT
, CGA.RESOURCE_ACCOUNT
, CGA.OVERHEAD_ACCOUNT
, CGA.OUTSIDE_PROCESSING_ACCOUNT
, CGA.AVERAGE_COST_VAR_ACCOUNT
, CGA.ENCUMBRANCE_ACCOUNT
, CGA.PAYBACK_MAT_VAR_ACCOUNT
, CGA.PAYBACK_RES_VAR_ACCOUNT
, CGA.PAYBACK_OSP_VAR_ACCOUNT
, CGA.PAYBACK_MOH_VAR_ACCOUNT
, CGA.PAYBACK_OVH_VAR_ACCOUNT
FROM CST_COST_GROUP_ACCOUNTS CGA
, MTL_PARAMETERS MP
WHERE CGA.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.PRIMARY_COST_METHOD IN (2
, 5
, 6)
AND CGA.COST_GROUP_ID != 1 UNION SELECT MP.ORGANIZATION_ID
, 1
, MP.MATERIAL_ACCOUNT
, MP.MATERIAL_OVERHEAD_ACCOUNT
, MP.RESOURCE_ACCOUNT
, MP.OVERHEAD_ACCOUNT
, MP.OUTSIDE_PROCESSING_ACCOUNT
, MP.AVERAGE_COST_VAR_ACCOUNT
, MP.ENCUMBRANCE_ACCOUNT
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MTL_PARAMETERS MP
WHERE MP.PRIMARY_COST_METHOD IN (2
, 5
, 6)

Columns