VIEW: APPS.EAM_DIRECT_ITEMS_V

Source

View Text - Preformatted

SELECT eed.wip_entity_id, eed.organization_id, eed.operations_dept_id, eed.operations_seq_num, bd.department_code, decode(eed.inventory_item_id, null, eed.item_description, (select msik.description from mtl_system_items_kfv msik where msik.inventory_item_id=eed.inventory_item_id and msik.organization_id=eed.organization_id )), eed.item_cost, eed.required_quantity, (select prha.segment1 from po_requisition_headers_all prha where prha.requisition_header_id=eed.requisition_header_id) , (select pha.segment1 from po_headers_all pha where pha.po_header_id=eed.po_header_id), eed.estimated_cost as total_direct_cost , decode (eed.inventory_item_id,null,null,(select msik.concatenated_segments from mtl_system_items_kfv msik where msik.inventory_item_id=eed.inventory_item_id and msik.organization_id=eed.organization_id)) from cst_eam_wo_estimate_details eed, bom_departments bd WHERE ((eed.requisition_header_id is not null and (eed.req_line_cancel_flag <> 'Y' or eed.req_line_cancel_flag is null) or eed.po_header_id is not null and (eed.po_line_cancel_flag <> 'Y' or eed.po_line_cancel_flag is null)) or eed.direct_item='Y') and eed.organization_id=bd.organization_id and bd.department_id=eed.owning_dept_id

View Text - HTML Formatted

SELECT EED.WIP_ENTITY_ID
, EED.ORGANIZATION_ID
, EED.OPERATIONS_DEPT_ID
, EED.OPERATIONS_SEQ_NUM
, BD.DEPARTMENT_CODE
, DECODE(EED.INVENTORY_ITEM_ID
, NULL
, EED.ITEM_DESCRIPTION
, (SELECT MSIK.DESCRIPTION
FROM MTL_SYSTEM_ITEMS_KFV MSIK
WHERE MSIK.INVENTORY_ITEM_ID=EED.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID=EED.ORGANIZATION_ID ))
, EED.ITEM_COST
, EED.REQUIRED_QUANTITY
, (SELECT PRHA.SEGMENT1
FROM PO_REQUISITION_HEADERS_ALL PRHA
WHERE PRHA.REQUISITION_HEADER_ID=EED.REQUISITION_HEADER_ID)
, (SELECT PHA.SEGMENT1
FROM PO_HEADERS_ALL PHA
WHERE PHA.PO_HEADER_ID=EED.PO_HEADER_ID)
, EED.ESTIMATED_COST AS TOTAL_DIRECT_COST
, DECODE (EED.INVENTORY_ITEM_ID
, NULL
, NULL
, (SELECT MSIK.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_KFV MSIK
WHERE MSIK.INVENTORY_ITEM_ID=EED.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID=EED.ORGANIZATION_ID))
FROM CST_EAM_WO_ESTIMATE_DETAILS EED
, BOM_DEPARTMENTS BD
WHERE ((EED.REQUISITION_HEADER_ID IS NOT NULL
AND (EED.REQ_LINE_CANCEL_FLAG <> 'Y' OR EED.REQ_LINE_CANCEL_FLAG IS NULL) OR EED.PO_HEADER_ID IS NOT NULL
AND (EED.PO_LINE_CANCEL_FLAG <> 'Y' OR EED.PO_LINE_CANCEL_FLAG IS NULL)) OR EED.DIRECT_ITEM='Y')
AND EED.ORGANIZATION_ID=BD.ORGANIZATION_ID
AND BD.DEPARTMENT_ID=EED.OWNING_DEPT_ID