DBA Data[Home] [Help]

APPS.GMDQC0_WF_P dependencies on SY_ORGN_MST

Line 115: l_orgn_code sy_orgn_mst.orgn_code%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey,'ORGN_CODE');

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;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;

Line 116: l_orgn_name sy_orgn_mst.orgn_name%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;
119: l_lot_no ic_lots_mst.lot_no%TYPE ;
120: l_sublot_no ic_lots_mst.sublot_no%TYPE ;

Line 170: FROM sy_orgn_mst

166: END IF;
167: /* Selecting Organization details from the organization mst */
168: SELECT orgn_name
169: INTO l_orgn_name
170: FROM sy_orgn_mst
171: WHERE orgn_code = l_orgn_code;
172:
173: /* Selecting Warehouse details from the Warehouse master mst */
174: SELECT whse_name