View: MTL_FISCAL_CAT_ACCOUNTS_V

Product:	INV - Inventory
Description:	PAC Category Accounts
Implementation/DBA Data:	APPS.MTL_FISCAL_CAT_ACCOUNTS_V

View Text

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

Columns