DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 747: FROM MTL_SYSTEM_ITEMS_KFV

743:
744: -- Cursor to check whether the item is trackable
745: CURSOR c_is_trackable_item(c_inventory_item_id NUMBER, c_inventory_org_id NUMBER) IS
746: SELECT COMMS_NL_TRACKABLE_FLAG
747: FROM MTL_SYSTEM_ITEMS_KFV
748: WHERE INVENTORY_ITEM_ID = c_inventory_item_id
749: AND ORGANIZATION_ID = c_inventory_org_id;
750:
751: --

Line 1537: FROM mtl_system_items_kfv

1533: WHERE line_id = c_oe_line_id;
1534:
1535: CURSOR get_item_number(c_inv_item_id NUMBER) IS
1536: SELECT concatenated_segments
1537: FROM mtl_system_items_kfv
1538: WHERE inventory_item_id = c_inv_item_id
1539: AND rownum = 1;
1540:
1541: CURSOR get_oe_line_id(c_osp_line_id NUMBER) IS