eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EAM_DIRECT_ITEM_RECS_V

Source

View Text - Preformatted


SELECT ewodi.DIRECT_ITEM_TYPE, ewodi.DIRECT_ITEM_TYPE_ID, ewodi.operation_seq_num , mc.concatenated_segments, ewodi.category_id, glob.currency_code, ewodi.item_name, ewodi.item_description, ewodi.uom_code, ewodi.wip_entity_id , ewodi.organization_id, nvl(ewodi.unit_price, ewodi.amount) as unit_price, ewodi.supplier_name, ewodi.vendor_id, ewodi.suggested_vendor_site, ewodi.suggested_vendor_site_id, ewodi.suggested_vendor_contact, ewodi.suggested_vendor_contact_id, ewodi.suggested_vendor_phone, ewodi.suggested_vendor_item_num, NVL(ewodi.QUANTITY_REQUIRED,0), ewodi.need_by_date, ewodi.auto_request_material, ewodi.item_id , ewodi.direct_item_sequence_id , nvl(ewodi.quantity_received,0), ewodi.department_id, ewodi.attribute_category, ewodi.attribute1, ewodi.attribute2, ewodi.attribute3, ewodi.attribute4, ewodi.attribute5, ewodi.attribute6, ewodi.attribute7, ewodi.attribute8, ewodi.attribute9, ewodi.attribute10, ewodi.attribute11, ewodi.attribute12, ewodi.attribute13, ewodi.attribute14, ewodi.attribute15, nvl(ewodi.RQL_QUANTITY_ORDERED,0), nvl(ewodi.po_quantity_ordered,0), nvl(ewodi.po_quantity_cancelled,0), ewodi.effectivity_control, ewodi.eam_item_type, ewodi.order_type_lookup_code, ewodi.amount, ewodi.amount_delivered, ewodi.rql_amount_ordered, ewodi.po_amount_ordered, DECODE(ewodi.order_type_lookup_code,'FIXED PRICE',2,1), ml.meaning from eam_work_order_direct_items_v ewodi, mfg_lookups ml, mtl_categories_kfv mc, hr_organization_information hoi, gl_sets_of_books glob WHERE ewodi.category_id = mc.category_id and DECODE(ewodi.order_type_lookup_code,'FIXED PRICE',2,1) = ml.lookup_code(+) and ml.lookup_type(+) = 'EAM_SERVICE_LINE_TYPE' and glob.set_of_books_id = hoi.ORG_INFORMATION1 and hoi.organization_id = ewodi.organization_id and hoi.ORG_INFORMATION_CONTEXT = 'Accounting Information' union all select ml.meaning , decode(eworp.item_id,null,1,2), eworp.operation_seq_num, mc.concatenated_segments, eworp.category_id, eworp.currency_code, msik.concatenated_segments, decode(eworp.item_id, null, eworp.item_description, msik.description), eworp.uom_code, eworp.wip_entity_id, eworp.ORGANIZATION_ID, nvl(eworp.unit_price, eworp.amount) as unit_price, eworp.vendor_name, eworp.vendor_id, eworp.vendor_site, eworp.vendor_site_id, eworp.vendor_contact, eworp.vendor_contact_id, eworp.vendor_phone, eworp.vendor_item_num, NVL( nvl(eworp.po_quantity_ordered, eworp.RQL_QUANTITY_ORDERED), 0), eworp.need_by_date, 'N', eworp.item_id, -1 as direct_item_sequence_id, nvl(eworp.quantity_received, 0), to_number(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), to_char(null), nvl(eworp.RQL_QUANTITY_ORDERED,0), nvl(eworp.po_quantity_ordered, 0), nvl(eworp.po_quantity_cancelled, 0), msik.effectivity_control, msik.eam_item_type, eworp.order_type_lookup_code, eworp.amount, eworp.amount_delivered, eworp.rql_amount_ordered, eworp.po_amount_ordered, DECODE(eworp.order_type_lookup_code,'FIXED PRICE',2,1), ml1.meaning from eam_work_order_req_po_v eworp, mfg_lookups ml1, mtl_system_items_b_kfv msik, mtl_categories_kfv mc, mfg_lookups ml where eworp.direct_item_sequence_id is null and DECODE(eworp.order_type_lookup_code,'FIXED PRICE',2,1) = ml1.lookup_code(+) and ml1.lookup_type(+) = 'EAM_SERVICE_LINE_TYPE' and nvl(eworp.QUANTITY_RECEIVED,-1) <= 0 and nvl(eworp.amount_delivered,-1) <= 0 and ( eworp.item_id is null OR not exists ( select 1 from wip_requirement_operations wro where wro.wip_entity_id = eworp.wip_entity_id and wro.operation_seq_num = eworp.operation_seq_num and wro.inventory_item_id = eworp.item_id ) ) and eworp.item_id = msik.inventory_item_id (+) and eworp.organization_id = msik.organization_id (+) and eworp.category_id = mc.category_id and ml.lookup_type='EAM_DIRECT_ITEM_TYPE' and ml.lookup_code=decode(eworp.item_id,null,1,2)

View Text - HTML Formatted

SELECT EWODI.DIRECT_ITEM_TYPE
, EWODI.DIRECT_ITEM_TYPE_ID
, EWODI.OPERATION_SEQ_NUM
, MC.CONCATENATED_SEGMENTS
, EWODI.CATEGORY_ID
, GLOB.CURRENCY_CODE
, EWODI.ITEM_NAME
, EWODI.ITEM_DESCRIPTION
, EWODI.UOM_CODE
, EWODI.WIP_ENTITY_ID
, EWODI.ORGANIZATION_ID
, NVL(EWODI.UNIT_PRICE
, EWODI.AMOUNT) AS UNIT_PRICE
, EWODI.SUPPLIER_NAME
, EWODI.VENDOR_ID
, EWODI.SUGGESTED_VENDOR_SITE
, EWODI.SUGGESTED_VENDOR_SITE_ID
, EWODI.SUGGESTED_VENDOR_CONTACT
, EWODI.SUGGESTED_VENDOR_CONTACT_ID
, EWODI.SUGGESTED_VENDOR_PHONE
, EWODI.SUGGESTED_VENDOR_ITEM_NUM
, NVL(EWODI.QUANTITY_REQUIRED
, 0)
, EWODI.NEED_BY_DATE
, EWODI.AUTO_REQUEST_MATERIAL
, EWODI.ITEM_ID
, EWODI.DIRECT_ITEM_SEQUENCE_ID
, NVL(EWODI.QUANTITY_RECEIVED
, 0)
, EWODI.DEPARTMENT_ID
, EWODI.ATTRIBUTE_CATEGORY
, EWODI.ATTRIBUTE1
, EWODI.ATTRIBUTE2
, EWODI.ATTRIBUTE3
, EWODI.ATTRIBUTE4
, EWODI.ATTRIBUTE5
, EWODI.ATTRIBUTE6
, EWODI.ATTRIBUTE7
, EWODI.ATTRIBUTE8
, EWODI.ATTRIBUTE9
, EWODI.ATTRIBUTE10
, EWODI.ATTRIBUTE11
, EWODI.ATTRIBUTE12
, EWODI.ATTRIBUTE13
, EWODI.ATTRIBUTE14
, EWODI.ATTRIBUTE15
, NVL(EWODI.RQL_QUANTITY_ORDERED
, 0)
, NVL(EWODI.PO_QUANTITY_ORDERED
, 0)
, NVL(EWODI.PO_QUANTITY_CANCELLED
, 0)
, EWODI.EFFECTIVITY_CONTROL
, EWODI.EAM_ITEM_TYPE
, EWODI.ORDER_TYPE_LOOKUP_CODE
, EWODI.AMOUNT
, EWODI.AMOUNT_DELIVERED
, EWODI.RQL_AMOUNT_ORDERED
, EWODI.PO_AMOUNT_ORDERED
, DECODE(EWODI.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 2
, 1)
, ML.MEANING
FROM EAM_WORK_ORDER_DIRECT_ITEMS_V EWODI
, MFG_LOOKUPS ML
, MTL_CATEGORIES_KFV MC
, HR_ORGANIZATION_INFORMATION HOI
, GL_SETS_OF_BOOKS GLOB
WHERE EWODI.CATEGORY_ID = MC.CATEGORY_ID
AND DECODE(EWODI.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 2
, 1) = ML.LOOKUP_CODE(+)
AND ML.LOOKUP_TYPE(+) = 'EAM_SERVICE_LINE_TYPE'
AND GLOB.SET_OF_BOOKS_ID = HOI.ORG_INFORMATION1
AND HOI.ORGANIZATION_ID = EWODI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION' UNION ALL SELECT ML.MEANING
, DECODE(EWORP.ITEM_ID
, NULL
, 1
, 2)
, EWORP.OPERATION_SEQ_NUM
, MC.CONCATENATED_SEGMENTS
, EWORP.CATEGORY_ID
, EWORP.CURRENCY_CODE
, MSIK.CONCATENATED_SEGMENTS
, DECODE(EWORP.ITEM_ID
, NULL
, EWORP.ITEM_DESCRIPTION
, MSIK.DESCRIPTION)
, EWORP.UOM_CODE
, EWORP.WIP_ENTITY_ID
, EWORP.ORGANIZATION_ID
, NVL(EWORP.UNIT_PRICE
, EWORP.AMOUNT) AS UNIT_PRICE
, EWORP.VENDOR_NAME
, EWORP.VENDOR_ID
, EWORP.VENDOR_SITE
, EWORP.VENDOR_SITE_ID
, EWORP.VENDOR_CONTACT
, EWORP.VENDOR_CONTACT_ID
, EWORP.VENDOR_PHONE
, EWORP.VENDOR_ITEM_NUM
, NVL( NVL(EWORP.PO_QUANTITY_ORDERED
, EWORP.RQL_QUANTITY_ORDERED)
, 0)
, EWORP.NEED_BY_DATE
, 'N'
, EWORP.ITEM_ID
, -1 AS DIRECT_ITEM_SEQUENCE_ID
, NVL(EWORP.QUANTITY_RECEIVED
, 0)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, NVL(EWORP.RQL_QUANTITY_ORDERED
, 0)
, NVL(EWORP.PO_QUANTITY_ORDERED
, 0)
, NVL(EWORP.PO_QUANTITY_CANCELLED
, 0)
, MSIK.EFFECTIVITY_CONTROL
, MSIK.EAM_ITEM_TYPE
, EWORP.ORDER_TYPE_LOOKUP_CODE
, EWORP.AMOUNT
, EWORP.AMOUNT_DELIVERED
, EWORP.RQL_AMOUNT_ORDERED
, EWORP.PO_AMOUNT_ORDERED
, DECODE(EWORP.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 2
, 1)
, ML1.MEANING
FROM EAM_WORK_ORDER_REQ_PO_V EWORP
, MFG_LOOKUPS ML1
, MTL_SYSTEM_ITEMS_B_KFV MSIK
, MTL_CATEGORIES_KFV MC
, MFG_LOOKUPS ML
WHERE EWORP.DIRECT_ITEM_SEQUENCE_ID IS NULL
AND DECODE(EWORP.ORDER_TYPE_LOOKUP_CODE
, 'FIXED PRICE'
, 2
, 1) = ML1.LOOKUP_CODE(+)
AND ML1.LOOKUP_TYPE(+) = 'EAM_SERVICE_LINE_TYPE'
AND NVL(EWORP.QUANTITY_RECEIVED
, -1) <= 0
AND NVL(EWORP.AMOUNT_DELIVERED
, -1) <= 0
AND ( EWORP.ITEM_ID IS NULL OR NOT EXISTS ( SELECT 1
FROM WIP_REQUIREMENT_OPERATIONS WRO
WHERE WRO.WIP_ENTITY_ID = EWORP.WIP_ENTITY_ID
AND WRO.OPERATION_SEQ_NUM = EWORP.OPERATION_SEQ_NUM
AND WRO.INVENTORY_ITEM_ID = EWORP.ITEM_ID ) )
AND EWORP.ITEM_ID = MSIK.INVENTORY_ITEM_ID (+)
AND EWORP.ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)
AND EWORP.CATEGORY_ID = MC.CATEGORY_ID
AND ML.LOOKUP_TYPE='EAM_DIRECT_ITEM_TYPE'
AND ML.LOOKUP_CODE=DECODE(EWORP.ITEM_ID
, NULL
, 1
, 2)