APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 612: From mtl_system_items_b

608: -- To validate if instance's item defined in job's org.
609: CURSOR mtl_system_kfv_csr(p_inventory_item_id IN NUMBER,
610: p_org_id IN NUMBER) IS
611: Select 'x'
612: From mtl_system_items_b
613: where inventory_item_id = p_inventory_item_id
614: and organization_id = p_org_id
615: and enabled_flag = 'Y';
616:

Line 1454: FROM mtl_system_items_b mtl, csi_item_instances csi

1450: l_msg_data varchar2(2000);
1451:
1452: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
1453: SELECT 'X'
1454: FROM mtl_system_items_b mtl, csi_item_instances csi
1455: WHERE csi.instance_id = p_instance_id
1456: AND csi.inventory_item_id = mtl.inventory_item_id
1457: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
1458: AND mtl.serial_number_control_code = 1;

Line 2084: FROM mtl_system_items_b mtl, csi_item_instances csi

2080: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2081:
2082: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
2083: SELECT 'X'
2084: FROM mtl_system_items_b mtl, csi_item_instances csi
2085: WHERE csi.instance_id = p_instance_id
2086: AND csi.inventory_item_id = mtl.inventory_item_id
2087: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
2088: AND mtl.serial_number_control_code = 1;

Line 3614: FROM mtl_system_items_b mtl, csi_item_instances csi

3610:
3611:
3612: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
3613: SELECT 'X'
3614: FROM mtl_system_items_b mtl, csi_item_instances csi
3615: WHERE csi.instance_id = p_instance_id
3616: AND csi.inventory_item_id = mtl.inventory_item_id
3617: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
3618: AND mtl.serial_number_control_code = 1;