View: CSTBV_PRODUCT_LINE_ACCOUNT

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTBV_PRODUCT_LINE_ACCOUNT

View Text

SELECT /* REGULAR ATTRIBUTE */ MCA.CATEGORY_ID
, MCA.ORGANIZATION_ID
, MCA.SUBINVENTORY_CODE
, MCA.COST_GROUP_ID
, '_KF:INV:MCAT:MC'
, MP.ORGANIZATION_CODE
, HAOU.NAME
, MCA.SUBINVENTORY_CODE
, CCG.COST_GROUP
, /* ID */ MCA.CATEGORY_SET_ID
, MCA.MATERIAL_ACCOUNT
, MCA.MATERIAL_OVERHEAD_ACCOUNT
, MCA.RESOURCE_ACCOUNT
, MCA.OUTSIDE_PROCESSING_ACCOUNT
, MCA.OVERHEAD_ACCOUNT
, MCA.EXPENSE_ACCOUNT
, MCA.ENCUMBRANCE_ACCOUNT
, MCA.BRIDGING_ACCOUNT
, MCA.ANALYTICAL_IPV
, MCA.ANALYTICAL_PO_MIRROR
, MCA.NON_INVOICED_SO
, MCA.NON_INVOICED_REVENUE
, MCA.ANALYTICAL_REVENUE_MIRROR
, MCA.ANALYTICAL_MOGS
, /* WHO */ MCA.CREATION_DATE
, MCA.CREATED_BY
, MCA.LAST_UPDATE_DATE
, MCA.LAST_UPDATED_BY
FROM MTL_CATEGORIES MC
, CST_COST_GROUPS CCG
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, MTL_CATEGORY_ACCOUNTS MCA
WHERE MCA.CATEGORY_ID = MC.CATEGORY_ID
AND HAOU.ORGANIZATION_ID = MCA.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MCA.ORGANIZATION_ID
AND CCG.ORGANIZATION_ID = MCA.ORGANIZATION_ID
AND '_SEC:MCA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns