VIEW: APPS.CST_AVG_DIST_ACCTS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)