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.CSTPOYUT dependencies on WIP_TRANSACTIONS

Line 157: FROM wip_entities we, wip_transactions wt

153: WSM_ESA_PKG_ERROR EXCEPTION;
154:
155: CURSOR c_wip_entities IS
156: SELECT distinct we.wip_entity_id
157: FROM wip_entities we, wip_transactions wt
158: WHERE we.wip_entity_id = wt.wip_entity_id
159: AND we.entity_type = 5
160: AND wt.group_id = i_group_id;
161:

Line 185: wip_transactions wt,

181: NVL(sum(acct.base_transaction_value), 0), 1,
182: i_req_id, i_prg_appl_id, i_prg_id, SYSDATE,
183: SYSDATE, i_user_id, i_login_id
184: FROM wip_transaction_accounts acct,
185: wip_transactions wt,
186: wip_entities we
187: WHERE we.wip_entity_id=c_we_rec.wip_entity_id
188: AND we.wip_entity_id = wt.wip_entity_id
189: AND we.entity_type = 5

Line 203: FROM wip_transactions wt,

199: woy.organization_id )
200: IN
201: (SELECT wt.wip_entity_id, wt.operation_seq_num,
202: wt.organization_id
203: FROM wip_transactions wt,
204: wip_transaction_accounts acct,
205: wip_entities we
206: WHERE wt.wip_entity_id=c_we_rec.wip_entity_id
207: AND wt.transaction_id = acct.transaction_id