eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMDQC0_WF_P dependencies on IC_LOTS_MST

Line 114: l_lot_id ic_lots_mst.lot_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'LOT_ID');

110: l_whse_item_id ic_item_mst.item_id%TYPE;
111: l_item_desc1 ic_item_mst.item_desc1%TYPE;
112: l_item_um ic_item_mst.item_um%TYPE;
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;

Line 119: l_lot_no ic_lots_mst.lot_no%TYPE ;

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;
123: l_role_name wf_roles.name%TYPE;

Line 120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;

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;
123: l_role_name wf_roles.name%TYPE;
124: l_role_display_name wf_roles.display_name%TYPE;

Line 161: FROM ic_lots_mst

157: /* Selecting lot details for the transaction occured */
158: IF l_lot_id <> 0 THEN
159: SELECT lot_no,sublot_no
160: INTO l_lot_no,l_sublot_no
161: FROM ic_lots_mst
162: WHERE lot_id = l_lot_id;
163: ELSE
164: l_lot_no:=NULL;
165: l_sublot_no:=NULL;