DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on OP_CUST_MST

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;