APPS.CSTPOYUT dependencies on WIP_ENTITIES

Line 155: CURSOR c_wip_entities IS

151: x_err_msg varchar2(240);
152: x_est_scrap_acct_flag NUMBER;
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

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 164: FOR c_we_rec IN c_wip_entities LOOP

160: AND wt.group_id = i_group_id;
161:
162: BEGIN
163:
164: FOR c_we_rec IN c_wip_entities LOOP
165: /* Update Wip_operation_yields */
166:
167: /* Changes for Optional Scrap */
168: x_est_scrap_acct_flag := WSMPUTIL.WSM_ESA_ENABLED(c_we_rec.wip_entity_id, x_err_num, x_err_msg);

Line 186: wip_entities we

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
190: AND wt.wip_entity_id = woy.wip_entity_id

Line 205: wip_entities we

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
208: AND acct.accounting_line_type = 7
209: AND we.wip_entity_id = wt.wip_entity_id