APPS.AHL_PRD_WORKORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1483: MTL_SYSTEM_ITEMS b

1479: ELSE
1480: SELECT COUNT(a.instance_id)
1481: INTO l_dummy_ctr
1482: FROM CSI_ITEM_INSTANCES a,
1483: MTL_SYSTEM_ITEMS b
1484: WHERE a.instance_id=p_prd_workorder_rec.item_instance_id
1485: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
1486: AND TRUNC(NVL(a.active_end_date,SYSDATE+1))
1487: AND a.inventory_item_id=b.inventory_item_id;

Line 2188: FROM MTL_SYSTEM_ITEMS

2184: CURSOR check_org_item (c_inventory_item_id NUMBER,
2185: c_org_id NUMBER)
2186: IS
2187: SELECT 'X'
2188: FROM MTL_SYSTEM_ITEMS
2189: WHERE inventory_item_id=c_inventory_item_id
2190: AND organization_id=c_org_id;
2191:
2192: l_mat_ctr NUMBER := 0;

Line 2314: FROM MTL_SYSTEM_ITEMS

2310: CURSOR check_org_item (c_inventory_item_id NUMBER,
2311: c_org_id NUMBER)
2312: IS
2313: SELECT 'X'
2314: FROM MTL_SYSTEM_ITEMS
2315: WHERE inventory_item_id=c_inventory_item_id
2316: AND organization_id=c_org_id;
2317:
2318: l_mat_ctr NUMBER := 0;