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_ITEM_MST

Line 30: l_item_no ic_item_mst.item_no%TYPE ;

26:
27: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
28:
29:
30: l_item_no ic_item_mst.item_no%TYPE ;
31: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
32: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
33: l_item_um ic_item_mst.item_um%TYPE ;
34: l_item_um2 ic_item_mst.item_um2%TYPE ;

Line 31: l_item_desc1 ic_item_mst.item_desc1%TYPE ;

27: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
28:
29:
30: l_item_no ic_item_mst.item_no%TYPE ;
31: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
32: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
33: l_item_um ic_item_mst.item_um%TYPE ;
34: l_item_um2 ic_item_mst.item_um2%TYPE ;
35: l_trans_qty NUMBER;

Line 32: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;

28:
29:
30: l_item_no ic_item_mst.item_no%TYPE ;
31: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
32: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
33: l_item_um ic_item_mst.item_um%TYPE ;
34: l_item_um2 ic_item_mst.item_um2%TYPE ;
35: l_trans_qty NUMBER;
36: l_WorkflowProcess VARCHAR2(30) := 'GMDQC0_PROCESS';

Line 33: l_item_um ic_item_mst.item_um%TYPE ;

29:
30: l_item_no ic_item_mst.item_no%TYPE ;
31: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
32: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
33: l_item_um ic_item_mst.item_um%TYPE ;
34: l_item_um2 ic_item_mst.item_um2%TYPE ;
35: l_trans_qty NUMBER;
36: l_WorkflowProcess VARCHAR2(30) := 'GMDQC0_PROCESS';
37: l_count NUMBER;

Line 34: l_item_um2 ic_item_mst.item_um2%TYPE ;

30: l_item_no ic_item_mst.item_no%TYPE ;
31: l_item_desc1 ic_item_mst.item_desc1%TYPE ;
32: l_dualum_ind ic_item_mst.dualum_ind%TYPE ;
33: l_item_um ic_item_mst.item_um%TYPE ;
34: l_item_um2 ic_item_mst.item_um2%TYPE ;
35: l_trans_qty NUMBER;
36: l_WorkflowProcess VARCHAR2(30) := 'GMDQC0_PROCESS';
37: l_count NUMBER;
38: BEGIN

Line 107: l_item_id ic_item_mst.item_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey, 'ITEM_ID');

103: p_funcmode IN VARCHAR2,
104: p_resultout OUT VARCHAR2
105: )
106: IS
107: l_item_id ic_item_mst.item_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey, 'ITEM_ID');
108: l_item_no ic_item_mst.item_no%TYPE;
109: l_whse_item_no Varchar2(32);
110: l_whse_item_id ic_item_mst.item_id%TYPE;
111: l_item_desc1 ic_item_mst.item_desc1%TYPE;

Line 108: l_item_no ic_item_mst.item_no%TYPE;

104: p_resultout OUT VARCHAR2
105: )
106: IS
107: l_item_id ic_item_mst.item_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey, 'ITEM_ID');
108: l_item_no ic_item_mst.item_no%TYPE;
109: l_whse_item_no Varchar2(32);
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;

Line 110: l_whse_item_id ic_item_mst.item_id%TYPE;

106: IS
107: l_item_id ic_item_mst.item_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey, 'ITEM_ID');
108: l_item_no ic_item_mst.item_no%TYPE;
109: l_whse_item_no Varchar2(32);
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');

Line 111: l_item_desc1 ic_item_mst.item_desc1%TYPE;

107: l_item_id ic_item_mst.item_id%TYPE:=wf_engine.getitemattrtext (p_itemtype, p_itemkey, 'ITEM_ID');
108: l_item_no ic_item_mst.item_no%TYPE;
109: l_whse_item_no Varchar2(32);
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');

Line 112: l_item_um ic_item_mst.item_um%TYPE;

108: l_item_no ic_item_mst.item_no%TYPE;
109: l_whse_item_no Varchar2(32);
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;

Line 113: l_item_um2 ic_item_mst.item_um2%TYPE;

109: l_whse_item_no Varchar2(32);
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');

Line 148: FROM ic_item_mst

144:
145: /* Selecting item details for the item on which the transaction has occured */
146: SELECT item_no,item_desc1,item_um,item_um2,whse_item_id
147: INTO l_item_no,l_item_desc1,l_item_um,l_item_um2,l_whse_item_id
148: FROM ic_item_mst
149: WHERE item_id = l_item_id;
150:
151: /* Select warehouse item details for the given item */
152: SELECT item_no

Line 154: FROM ic_item_mst

150:
151: /* Select warehouse item details for the given item */
152: SELECT item_no
153: INTO l_whse_item_no
154: FROM ic_item_mst
155: WHERE item_id = l_whse_item_id;
156:
157: /* Selecting lot details for the transaction occured */
158: IF l_lot_id <> 0 THEN