APPS.PO_GML_DB_COMMON dependencies on IC_WHSE_MST

Line 173: l_whse_code ic_whse_mst.whse_code%TYPE;

169: ,plocator_id IN NUMBER
170: ) RETURN NUMBER IS
171:
172: v_progress VARCHAR2(3) := '010';
173: l_whse_code ic_whse_mst.whse_code%TYPE;
174: l_location ic_loct_mst.location%TYPE;
175: l_quantity_onhand NUMBER;
176: l_lot_id ic_lots_mst.lot_id%TYPE;
177: BEGIN

Line 205: from ic_whse_mst

201: END;
202:
203: --get whse code
204: select whse_code INTO l_whse_code
205: from ic_whse_mst
206: where mtl_organization_id = porg_id;
207:
208:
209: --get location code

Line 411: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;

407: l_tran_rec gmi_trans_engine_pub.ictran_rec;
408:
409: l_whse_code ic_tran_pnd.whse_code%TYPE;
410: l_orgn_code ic_tran_pnd.orgn_code%TYPE;
411: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
412: l_item_loct_ctl ic_item_mst.loct_ctl%TYPE;
413: l_item_lot_ctl ic_item_mst.lot_ctl%TYPE;
414: l_co_code ic_tran_pnd.co_code%TYPE;
415: l_item_id ic_tran_pnd.item_id%TYPE;

Line 787: FROM ic_whse_mst w, sy_orgn_mst o

783: /* Get the whse, orgn and the company codes */
784: BEGIN
785: SELECT w.whse_code, w.orgn_code, o.co_code,w.loct_ctl
786: INTO l_whse_code, l_orgn_code, l_co_code, l_loct_ctl
787: FROM ic_whse_mst w, sy_orgn_mst o
788: WHERE mtl_organization_id = l_organization_id
789: AND w.orgn_code = o.orgn_code;
790:
791: EXCEPTION

Line 1435: l_error_message := x_return_Status||' No data found in IC_WHSE_MST for organization with id '||to_char(l_organization_id);

1431: IF x_return_status = '-5' THEN
1432: l_error_message := x_return_Status||' No data found in RCV_TRANSACTIONS_INTERFACE';
1433:
1434: ELSIF x_return_status = '-10' THEN
1435: l_error_message := x_return_Status||' No data found in IC_WHSE_MST for organization with id '||to_char(l_organization_id);
1436:
1437: ELSIF x_return_status = '-20' THEN
1438: l_error_message := x_return_Status||' No data found in IC_ITEM_MST for item with id '||to_char(l_ora_item_id);
1439: