APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 645: From mtl_system_items_b

641: -- To validate if instance's item defined in job's org.
642: CURSOR mtl_system_kfv_csr(p_inventory_item_id IN NUMBER,
643: p_org_id IN NUMBER) IS
644: Select 'x'
645: From mtl_system_items_b
646: where inventory_item_id = p_inventory_item_id
647: and organization_id = p_org_id
648: and enabled_flag = 'Y';
649:

Line 1487: FROM mtl_system_items_b mtl, csi_item_instances csi

1483: l_msg_data varchar2(2000);
1484:
1485: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
1486: SELECT 'X'
1487: FROM mtl_system_items_b mtl, csi_item_instances csi
1488: WHERE csi.instance_id = p_instance_id
1489: AND csi.inventory_item_id = mtl.inventory_item_id
1490: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
1491: AND mtl.serial_number_control_code = 1;

Line 2134: FROM mtl_system_items_b mtl, csi_item_instances csi

2130: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2131:
2132: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
2133: SELECT 'X'
2134: FROM mtl_system_items_b mtl, csi_item_instances csi
2135: WHERE csi.instance_id = p_instance_id
2136: AND csi.inventory_item_id = mtl.inventory_item_id
2137: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
2138: AND mtl.serial_number_control_code = 1;

Line 3671: FROM mtl_system_items_b mtl, csi_item_instances csi

3667:
3668:
3669: CURSOR check_inst_nonserial(p_instance_id IN NUMBER) IS
3670: SELECT 'X'
3671: FROM mtl_system_items_b mtl, csi_item_instances csi
3672: WHERE csi.instance_id = p_instance_id
3673: AND csi.inventory_item_id = mtl.inventory_item_id
3674: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
3675: AND mtl.serial_number_control_code = 1;