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 307: WIP_OPERATION_RESOURCES WOR,

303: begin
304: SELECT COUNT(1)
305: INTO x_no_move_count
306: FROM WIP_OPERATIONS WOP,
307: WIP_OPERATION_RESOURCES WOR,
308: WIP_PARAMETERS WP,
309: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
310: WIP_SHOP_FLOOR_STATUSES WSFS
311: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */

Line 318: (Select 'X' from WIP_OPERATION_RESOURCES WOR1

314: AND WP.ORGANIZATION_ID = p_org_id
315: AND NVL(WP.MOVES_OVER_NO_MOVE_STATUSES, 1) = 2 /* No */
316: /* Fix for bug 2121222 */
317: AND NOT EXISTS
318: (Select 'X' from WIP_OPERATION_RESOURCES WOR1
319: WHERE WOR1.WIP_ENTITY_ID = p_wip_id
320: AND WOR1.ORGANIZATION_ID = p_org_id
321: AND WOR1.OPERATION_SEQ_NUM = p_fm_op
322: AND (WOR1.REPETITIVE_SCHEDULE_ID = p_sched_id