APPS.AHL_PRD_WORKORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1615: MTL_SYSTEM_ITEMS b

1611: ELSE
1612: SELECT COUNT(a.instance_id)
1613: INTO l_dummy_ctr
1614: FROM CSI_ITEM_INSTANCES a,
1615: MTL_SYSTEM_ITEMS b
1616: WHERE a.instance_id=p_prd_workorder_rec.item_instance_id
1617: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
1618: AND TRUNC(NVL(a.active_end_date,SYSDATE+1))
1619: AND a.inventory_item_id=b.inventory_item_id;

Line 2865: FROM MTL_SYSTEM_ITEMS

2861: CURSOR check_org_item (c_inventory_item_id NUMBER,
2862: c_org_id NUMBER)
2863: IS
2864: SELECT 'X'
2865: FROM MTL_SYSTEM_ITEMS
2866: WHERE inventory_item_id=c_inventory_item_id
2867: AND organization_id=c_org_id;
2868:
2869: l_mat_ctr NUMBER := 0;

Line 3108: FROM MTL_SYSTEM_ITEMS

3104: CURSOR check_org_item (c_inventory_item_id NUMBER,
3105: c_org_id NUMBER)
3106: IS
3107: SELECT 'X'
3108: FROM MTL_SYSTEM_ITEMS
3109: WHERE inventory_item_id=c_inventory_item_id
3110: AND organization_id=c_org_id;
3111:
3112: l_mat_ctr NUMBER := 0;

Line 11263: FROM mtl_system_items_kfv

11259: Fnd_Message.Set_Token('VISIT',p_visit_number);
11260: -- get inv segments.
11261: BEGIN
11262: SELECT concatenated_segments INTO l_inv_segments
11263: FROM mtl_system_items_kfv
11264: WHERE inventory_item_id = mtl_rec.inventory_item_id
11265: and rownum < 2;
11266:
11267: EXCEPTION