APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 976: FROM mtl_system_items_b

972: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
973: -- Cursor to check whether the disposition item is serialized or not.
974: CURSOR chk_non_serialized_csr(p_inventory_item_id NUMBER, p_item_org_id NUMBER) IS
975: SELECT 'X'
976: FROM mtl_system_items_b
977: WHERE inventory_item_id = p_inventory_item_id
978: AND organization_id = p_item_org_id
979: AND serial_number_control_code = 1;
980:

Line 1556: FROM mtl_system_items_b

1552: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1553: -- Cursor to check whether the disposition item is serialized or not.
1554: CURSOR chk_non_serialized_csr(p_inventory_item_id NUMBER, p_item_org_id NUMBER) IS
1555: SELECT 'X'
1556: FROM mtl_system_items_b
1557: WHERE inventory_item_id = p_inventory_item_id
1558: AND organization_id = p_item_org_id
1559: AND serial_number_control_code = 1;
1560:

Line 3360: FROM mtl_system_items_b

3356: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 13-Dec-2007
3357: -- Cursor to check whether the disposition item is serialized or not.
3358: CURSOR chk_non_serialized_csr(p_inventory_item_id NUMBER, p_item_org_id NUMBER) IS
3359: SELECT 'X'
3360: FROM mtl_system_items_b
3361: WHERE inventory_item_id = p_inventory_item_id
3362: AND organization_id = p_item_org_id
3363: AND serial_number_control_code = 1;
3364:

Line 4350: FROM mtl_system_items_b mtl, csi_item_instances csi

4346: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 13-Dec-2007
4347: -- Cursor to check whether the disposition item is serialized or not.
4348: CURSOR chk_non_serialized_csr(p_instance_id NUMBER) IS
4349: SELECT 'X'
4350: FROM mtl_system_items_b mtl, csi_item_instances csi
4351: WHERE csi.instance_id = p_instance_id
4352: AND csi.inventory_item_id = mtl.inventory_item_id
4353: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
4354: AND mtl.serial_number_control_code = 1;