APPS.XDP_ORDER dependencies on MTL_SYSTEM_ITEMS

Line 280: FROM mtl_system_items_b msi,

276: /*** Cursor to check if the passed inventory_item_id is a package ? ***/
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

Line 293: FROM mtl_system_items msib

289: AND bic.bill_sequence_id = bom.bill_sequence_id
290: AND NVL(bic.disable_date,sysdate) >= sysdate
291: AND NVL(bic.effectivity_date,sysdate) <= sysdate
292: AND EXISTS(SELECT 'Y'
293: FROM mtl_system_items msib
294: WHERE msib.organization_id = p_organization_id
295: AND msib.inventory_item_id = bic.component_item_id
296: AND msib.comms_activation_reqd_flag = 'Y');
297: BEGIN

Line 506: mtl_system_items_vl msi

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
509: AND bic.bill_sequence_id = bom.bill_sequence_id
510: AND NVL(bic.disable_date,sysdate) >= sysdate

Line 1578: FROM mtl_system_items_vl

1574: concatenated_segments
1575: INTO lv_inventory_item_id,
1576: lv_activation_flag,
1577: lv_item_number
1578: FROM mtl_system_items_vl
1579: WHERE organization_id = p_organization_id
1580: AND inventory_item_id = p_inventory_item_id
1581: AND NVL(start_date_active,sysdate) <= sysdate
1582: AND NVL(end_date_active,sysdate) >= sysdate ;

Line 1607: FROM mtl_system_items_vl

1603: SELECT inventory_item_id,
1604: comms_activation_reqd_flag
1605: INTO lv_inventory_item_id,
1606: lv_activation_flag
1607: FROM mtl_system_items_vl
1608: WHERE organization_id = p_organization_id
1609: AND concatenated_segments = p_item_number
1610: AND NVL(start_date_active,sysdate) <= sysdate
1611: AND NVL(end_date_active,sysdate) >= sysdate ;

Line 2616: mtl_system_items_vl msi

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
2619: AND bic.bill_sequence_id = bom.bill_sequence_id
2620: AND NVL(bic.effectivity_date,sysdate) <= sysdate