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.WIP_SF_STATUS dependencies on WIP_OPERATION_RESOURCES

Line 210: FROM wip_operation_resources wo

206:
207: CURSOR cwop IS
208: SELECT
209: wo.operation_seq_num
210: FROM wip_operation_resources wo
211: WHERE wo.wip_entity_id = p_wip_entity_id
212: AND wo.organization_id = p_org_id
213: AND nvl (wo.repetitive_schedule_id, -1) = nvl(p_repetitive_sched_id,-1)
214: AND wo.autocharge_type = WIP_CONSTANTS.PO_MOVE;

Line 255: FROM wip_operation_resources wo

251:
252: CURSOR cwop IS
253: SELECT
254: wo.operation_seq_num
255: FROM wip_operation_resources wo
256: WHERE wo.wip_entity_id = p_wip_entity_id
257: AND wo.organization_id = p_org_id
258: AND nvl (wo.repetitive_schedule_id, -1) = nvl(p_repetitive_sched_id,-1)
259: AND wo.autocharge_type = WIP_CONSTANTS.PO_MOVE;

Line 314: from WIP_OPERATION_RESOURCES WOR1

310: where wp.organization_id = p_org_id;
311:
312: Select count(*)
313: into l_num_rcv_txn
314: from WIP_OPERATION_RESOURCES WOR1
315: WHERE WOR1.WIP_ENTITY_ID = p_wip_id
316: AND WOR1.ORGANIZATION_ID = p_org_id
317: AND WOR1.OPERATION_SEQ_NUM = p_fm_op
318: AND (WOR1.REPETITIVE_SCHEDULE_ID = p_sched_id

Line 326: WIP_OPERATION_RESOURCES WOR,

322:
323: SELECT COUNT(1)
324: INTO x_no_move_count
325: FROM WIP_OPERATIONS WOP,
326: WIP_OPERATION_RESOURCES WOR,
327: WIP_PARAMETERS WP,
328: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
329: WIP_SHOP_FLOOR_STATUSES WSFS
330: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */

Line 502: WIP_OPERATION_RESOURCES WOR,

498: begin
499: SELECT WSFS.SHOP_FLOOR_STATUS_CODE
500: INTO x_sf_status
501: FROM WIP_OPERATIONS WOP,
502: WIP_OPERATION_RESOURCES WOR,
503: WIP_PARAMETERS WP,
504: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
505: WIP_SHOP_FLOOR_STATUSES WSFS
506: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */

Line 513: (Select 'X' from WIP_OPERATION_RESOURCES WOR1

509: AND WP.ORGANIZATION_ID = p_org_id
510: AND NVL(WP.MOVES_OVER_NO_MOVE_STATUSES, 1) = 2 /* No */
511: /* Fix for bug 2121222 */
512: AND NOT EXISTS
513: (Select 'X' from WIP_OPERATION_RESOURCES WOR1
514: WHERE WOR1.WIP_ENTITY_ID = p_wip_id
515: AND WOR1.ORGANIZATION_ID = p_org_id
516: AND WOR1.OPERATION_SEQ_NUM = p_fm_op
517: AND (WOR1.REPETITIVE_SCHEDULE_ID = p_sched_id