APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on IC_WHSE_MST

Line 2674: FROM IC_WHSE_MST

2670:
2671: CURSOR c_get_org_id ( l_whse_code in VARCHAR)
2672: IS
2673: SELECT MTL_ORGANIZATION_ID
2674: FROM IC_WHSE_MST
2675: WHERE WHSE_CODE = l_whse_code;
2676:
2677: CURSOR c_get_inv_item_id ( l_org_id in NUMBER,l_item_no In VARCHAR)
2678: IS

Line 2687: FROM OP_CUST_MST C, IC_WHSE_MST I, SY_ORGN_MST S

2683:
2684: CURSOR c_get_ship_to_id ( l_cust_num IN VARCHAR, l_whse_code IN VARCHAR)
2685: IS
2686: SELECT C.OF_SHIP_TO_SITE_USE_ID
2687: FROM OP_CUST_MST C, IC_WHSE_MST I, SY_ORGN_MST S
2688: WHERE S.ORGN_CODE = i.ORGN_CODE
2689: AND S.CO_CODE = C.CO_CODE
2690: AND I.WHSE_CODE = l_whse_code
2691: AND CUST_NO = l_cust_num;

Line 3417: From ic_whse_mst

3413: Where line_id = l_txn_source_line_id;
3414:
3415: Select mtl_organization_id
3416: Into l_organization_id
3417: From ic_whse_mst
3418: Where whse_code = l_trans_rec.whse_code;
3419:
3420: GMI_Reservation_Util.PrintLn('om line ship_from_org_id '||l_ship_from_org_id );
3421: GMI_Reservation_Util.PrintLn('trans organization_id'||l_organization_id);

Line 3458: From ic_whse_mst

3454: END IF;
3455:
3456: Select whse_code
3457: Into l_trans_rec.whse_code
3458: From ic_whse_mst
3459: Where mtl_organization_id = l_ship_from_org_id
3460: and rownum = 1; -- just in case, should only have 1 row
3461:
3462: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION