APPS.GMDQC0_WF_P dependencies on IC_WHSE_MST

Line 117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');

113: l_item_um2 ic_item_mst.item_um2%TYPE;
114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');
115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');
116: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
121: l_doc_type sy_docs_mst.doc_type%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_TYPE');

Line 118: l_whse_name ic_whse_mst.whse_name%TYPE;

114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');
115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');
116: l_orgn_name sy_orgn_mst.orgn_name%TYPE;
117: l_whse_code ic_whse_mst.whse_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'WHSE_CODE');
118: l_whse_name ic_whse_mst.whse_name%TYPE;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;
121: l_doc_type sy_docs_mst.doc_type%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'DOC_TYPE');
122: l_doc_desc sy_docs_mst.doc_desc%TYPE;

Line 176: FROM ic_whse_mst

172:
173: /* Selecting Warehouse details from the Warehouse master mst */
174: SELECT whse_name
175: INTO l_whse_name
176: FROM ic_whse_mst
177: WHERE whse_code = l_whse_code;
178:
179: /* Selecting Document details from Document Master */
180: SELECT doc_desc