APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 973: FROM mtl_system_items_b

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

Line 1396: FROM mtl_system_items_b

1392: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1393: -- Cursor to check whether the disposition item is serialized or not.
1394: CURSOR chk_non_serialized_csr(p_inventory_item_id NUMBER, p_item_org_id NUMBER) IS
1395: SELECT 'X'
1396: FROM mtl_system_items_b
1397: WHERE inventory_item_id = p_inventory_item_id
1398: AND organization_id = p_item_org_id
1399: AND serial_number_control_code = 1;
1400:

Line 2937: FROM mtl_system_items_b

2933: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 13-Dec-2007
2934: -- Cursor to check whether the disposition item is serialized or not.
2935: CURSOR chk_non_serialized_csr(p_inventory_item_id NUMBER, p_item_org_id NUMBER) IS
2936: SELECT 'X'
2937: FROM mtl_system_items_b
2938: WHERE inventory_item_id = p_inventory_item_id
2939: AND organization_id = p_item_org_id
2940: AND serial_number_control_code = 1;
2941:

Line 3890: FROM mtl_system_items_b mtl, csi_item_instances csi

3886: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 13-Dec-2007
3887: -- Cursor to check whether the disposition item is serialized or not.
3888: CURSOR chk_non_serialized_csr(p_instance_id NUMBER) IS
3889: SELECT 'X'
3890: FROM mtl_system_items_b mtl, csi_item_instances csi
3891: WHERE csi.instance_id = p_instance_id
3892: AND csi.inventory_item_id = mtl.inventory_item_id
3893: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
3894: AND mtl.serial_number_control_code = 1;