DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on MTL_SYSTEM_ITEMS

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)

Line 3648: FROM mtl_system_items

3644: FOR UPDATE;
3645:
3646: cursor c_primary_uom IS
3647: SELECT primary_uom_code
3648: FROM mtl_system_items
3649:
3650: WHERE organization_Id = l_organization_id
3651: AND inventory_Item_Id = l_inventory_Item_Id;
3652: