VIEW: APPS.CST_MGD_LIFO_ITEM_COSTS_V

Source

View Text - Preformatted

SELECT pic.rowid row_id, pic.cost_layer_id, pic.creation_date, pic.created_by, pic.last_update_date, pic.last_updated_by, pic.last_update_login, pp.legal_entity legal_entity_id, pic.pac_period_id, pic.cost_group_id, pp.cost_type_id, pic.inventory_item_id, msi.description inventory_item_description, msi.primary_uom_code uom_code, pic.item_cost, pic.market_value, pic.justification, pic.request_id, pic.program_application_id, pic.program_id, pic.program_update_date, pic.attribute_category, pic.attribute1, pic.attribute2, pic.attribute3, pic.attribute4, pic.attribute5, pic.attribute6, pic.attribute7, pic.attribute8, pic.attribute9, pic.attribute10, pic.attribute11, pic.attribute12, pic.attribute13, pic.attribute14, pic.attribute15 FROM cst_pac_item_costs pic, cst_cost_groups cg, cst_pac_periods pp, cst_cost_types ct, xle_firstparty_information_v xfi, mtl_system_items_vl msi WHERE cg.cost_group_id = pic.cost_group_id AND pp.pac_period_id = pic.pac_period_id AND pp.cost_type_id = ct.cost_type_id AND xfi.legal_entity_id = pp.legal_entity AND msi.organization_id = cg.organization_id AND msi.inventory_item_id = pic.inventory_item_id

View Text - HTML Formatted

SELECT PIC.ROWID ROW_ID
, PIC.COST_LAYER_ID
, PIC.CREATION_DATE
, PIC.CREATED_BY
, PIC.LAST_UPDATE_DATE
, PIC.LAST_UPDATED_BY
, PIC.LAST_UPDATE_LOGIN
, PP.LEGAL_ENTITY LEGAL_ENTITY_ID
, PIC.PAC_PERIOD_ID
, PIC.COST_GROUP_ID
, PP.COST_TYPE_ID
, PIC.INVENTORY_ITEM_ID
, MSI.DESCRIPTION INVENTORY_ITEM_DESCRIPTION
, MSI.PRIMARY_UOM_CODE UOM_CODE
, PIC.ITEM_COST
, PIC.MARKET_VALUE
, PIC.JUSTIFICATION
, PIC.REQUEST_ID
, PIC.PROGRAM_APPLICATION_ID
, PIC.PROGRAM_ID
, PIC.PROGRAM_UPDATE_DATE
, PIC.ATTRIBUTE_CATEGORY
, PIC.ATTRIBUTE1
, PIC.ATTRIBUTE2
, PIC.ATTRIBUTE3
, PIC.ATTRIBUTE4
, PIC.ATTRIBUTE5
, PIC.ATTRIBUTE6
, PIC.ATTRIBUTE7
, PIC.ATTRIBUTE8
, PIC.ATTRIBUTE9
, PIC.ATTRIBUTE10
, PIC.ATTRIBUTE11
, PIC.ATTRIBUTE12
, PIC.ATTRIBUTE13
, PIC.ATTRIBUTE14
, PIC.ATTRIBUTE15
FROM CST_PAC_ITEM_COSTS PIC
, CST_COST_GROUPS CG
, CST_PAC_PERIODS PP
, CST_COST_TYPES CT
, XLE_FIRSTPARTY_INFORMATION_V XFI
, MTL_SYSTEM_ITEMS_VL MSI
WHERE CG.COST_GROUP_ID = PIC.COST_GROUP_ID
AND PP.PAC_PERIOD_ID = PIC.PAC_PERIOD_ID
AND PP.COST_TYPE_ID = CT.COST_TYPE_ID
AND XFI.LEGAL_ENTITY_ID = PP.LEGAL_ENTITY
AND MSI.ORGANIZATION_ID = CG.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = PIC.INVENTORY_ITEM_ID