VIEW: APPS.MTL_FISCAL_CAT_ACCOUNTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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