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.

APPS.XDP_ORDER dependencies on BOM_BILL_OF_MATERIALS

Line 281: bom_bill_of_materials bom,

277:
278: CURSOR c_items IS
279: SELECT msi.inventory_item_id
280: FROM mtl_system_items_b msi,
281: bom_bill_of_materials bom,
282: bom_inventory_components bic
283: WHERE msi.organization_id = p_organization_id
284: AND msi.inventory_item_id = p_inventory_item_id
285: AND NVL(msi.start_date_active,sysdate)<= sysdate

Line 504: FROM bom_bill_of_materials bom,

500: /*** Cursor to determine components of a package ***/
501: CURSOR c_comp IS
502: SELECT bic.component_item_id,
503: msi.concatenated_segments item_number
504: FROM bom_bill_of_materials bom,
505: bom_inventory_components bic ,
506: mtl_system_items_vl msi
507: WHERE bom.organization_id = p_organization_id
508: AND bom.assembly_item_id = p_inventory_item_id

Line 2614: FROM bom_bill_of_materials bom,

2610: bic.component_quantity ,
2611: bic.item_num ,
2612: bic.operation_seq_num,
2613: msi.concatenated_segments item_number
2614: FROM bom_bill_of_materials bom,
2615: bom_inventory_components bic,
2616: mtl_system_items_vl msi
2617: WHERE bom.organization_id = p_organization_id
2618: AND bom.assembly_item_id = p_inventory_item_id