Product: | INV - Inventory |
---|---|
Description: | PAC Category Accounts |
Implementation/DBA Data: | APPS.MTL_FISCAL_CAT_ACCOUNTS_V |
SELECT MFC.ROWID ROW_ID
, MFC.LEGAL_ENTITY_ID
, MFC.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION COST_TYPE_DESCRIPTION
, MFC.COST_GROUP_ID
, XLE.NAME LEGAL_ENTITY
, MFC.CATEGORY_ID
, MFC.LAST_UPDATE_DATE
, MFC.LAST_UPDATED_BY
, MFC.CREATION_DATE
, MFC.CREATED_BY
, MFC.LAST_UPDATE_LOGIN
, MFC.MATERIAL_ACCOUNT
, MFC.MATERIAL_OVERHEAD_ACCOUNT
, MFC.RESOURCE_ACCOUNT
, MFC.OUTSIDE_PROCESSING_ACCOUNT
, MFC.OVERHEAD_ACCOUNT
, MFC.EXPENSE_ACCOUNT
, MFC.BRIDGING_ACCOUNT
, MFC.NON_INVOICED_SO NON_INVOICED_SO_ACCOUNT
, MFC.NON_INVOICED_REVENUE NON_INVOICED_REVENUE_ACCOUNT
, MC.DESCRIPTION CATEGORY_DESCRIPTION
, CCG.COST_GROUP COST_GROUP_NAME
, CCG.DESCRIPTION COST_GROUP_DESCRIPTION
, GSOB.NAME SET_OF_BOOKS_NAME
, GSOB.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
FROM CST_COST_GROUPS CCG
, MTL_FISCAL_CAT_ACCOUNTS MFC
, GL_SETS_OF_BOOKS GSOB
, CST_LE_COST_TYPES CLCT
, CST_COST_TYPES CCT
, MTL_CATEGORIES MC
, XLE_FIRSTPARTY_INFORMATION_V XLE
WHERE MFC.COST_GROUP_ID = CCG.COST_GROUP_ID
AND MFC.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND MFC.CATEGORY_ID = MC.CATEGORY_ID
AND MFC.LEGAL_ENTITY_ID = CLCT.LEGAL_ENTITY
AND MFC.COST_TYPE_ID = CLCT.COST_TYPE_ID
AND CLCT.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND MFC.COST_TYPE_ID = CCT.COST_TYPE_ID
AND XLE.LEGAL_ENTITY_ID = MFC.LEGAL_ENTITY_ID