APPS.GMI_RESERVATION_UTIL dependencies on OP_CUST_MST

Line 756: of op_cust_mst

752:
753: --B1731567 - Retrieve co_code associated with cust_no to give the customer key
754: --============================================================================
755: /* bug 2245351, to carry the code forward without forking, we will eliminate the use
756: of op_cust_mst
757: the co_code should be same as g_co_code */
758: CURSOR c_customer_and_so_info (oe_line_id IN NUMBER) IS
759: SELECT oel.sold_to_org_id
760: , oel.ship_to_org_id

Line 2310: l_cust_no op_cust_mst.cust_no%TYPE;

2306: /* For the Allocation rules. */
2307: l_op_alot_prm_rec op_alot_prm%ROWTYPE;
2308: l_inventory_item_id NUMBER;
2309: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
2310: l_cust_no op_cust_mst.cust_no%TYPE;
2311: l_co_code op_cust_mst.co_code%TYPE; --B1731567 co_code of cust
2312:
2313: /* added by fabdi 20/08/2001 Bug 2023369 */
2314: locked_by_other_user EXCEPTION;

Line 2311: l_co_code op_cust_mst.co_code%TYPE; --B1731567 co_code of cust

2307: l_op_alot_prm_rec op_alot_prm%ROWTYPE;
2308: l_inventory_item_id NUMBER;
2309: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
2310: l_cust_no op_cust_mst.cust_no%TYPE;
2311: l_co_code op_cust_mst.co_code%TYPE; --B1731567 co_code of cust
2312:
2313: /* added by fabdi 20/08/2001 Bug 2023369 */
2314: locked_by_other_user EXCEPTION;
2315: PRAGMA EXCEPTION_INIT (locked_by_other_user,-54);

Line 2358: From op_cust_mst opc

2354: AND sol.line_id = so_line_id ;
2355:
2356: Cursor get_cust_no IS
2357: Select opc.cust_no
2358: From op_cust_mst opc
2359: , sy_orgn_mst som
2360: , ic_whse_mst whse
2361: Where whse.mtl_organization_id = l_organization_id
2362: and whse.orgn_code = som.orgn_code