DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on IC_ITEM_MST

Line 2663: FROM IC_ITEM_MST i, MTL_SYSTEM_ITEMS m

2659: AND whse_code = l_whse_code;
2660:
2661: cursor c_item_info IS
2662: SELECT i.item_id, i.item_no,i.alloc_class
2663: FROM IC_ITEM_MST i, MTL_SYSTEM_ITEMS m
2664: WHERE m.organization_id = l_org_id
2665: And m.inventory_item_id = l_inv_item_id
2666: AND i.item_no = m.segment1;
2667:

Line 2680: FROM IC_ITEM_MST i, MTL_SYSTEM_ITEMS m

2676:
2677: CURSOR c_get_inv_item_id ( l_org_id in NUMBER,l_item_no In VARCHAR)
2678: IS
2679: SELECT m.inventory_item_id
2680: FROM IC_ITEM_MST i, MTL_SYSTEM_ITEMS m
2681: WHERE m.organization_id = l_org_id
2682: AND m.segment1 = l_item_no;
2683:
2684: CURSOR c_get_ship_to_id ( l_cust_num IN VARCHAR, l_whse_code IN VARCHAR)