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_WS_EMBEDDED_ANALYTICS_PK dependencies on WIP_OPERATIONS

Line 191: wip_operations wop

187: wmt.transaction_date > p_cutoff_date
188: AND wmt.organization_id = p_org_id
189: )
190: ) wmt,
191: wip_operations wop
192: WHERE
193: wop.organization_id = p_org_id
194: AND wop.wip_entity_id = wmt.wip_entity_id
195: AND ((wop.operation_seq_num >= wmt.fm_operation_seq_num + DECODE(SIGN(wmt.fm_intraoperation_step_type - WIP_CONSTANTS.RUN),1,1,0)

Line 317: wip_operations wop

313: wmt.transaction_date,
314: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id,wop.department_id, wmt.transaction_date) as shift_info
315: FROM
316: wip_move_transactions wmt,
317: wip_operations wop
318: WHERE
319: wmt.transaction_date >= p_cutoff_date
320: AND wmt.organization_id = p_org_id
321: AND wop.organization_id = p_org_id

Line 396: wip_operations wop

392: AND (wmt.fm_intraoperation_step_type = WIP_CONSTANTS.SCRAP
393: OR wmt.to_intraoperation_step_type = WIP_CONSTANTS.SCRAP)
394: ) wmt_raw_shift_info
395: ) wmt,
396: wip_operations wop
397:
398: WHERE
399: wop.wip_entity_id = wmt.wip_entity_id
400: AND wop.organization_id = p_org_id

Line 432: wip_operations wop

428: wop.wip_entity_id, wop.operation_seq_num,
429: wmt.transaction_date,wmt.primary_quantity,wmt.to_intraoperation_step_type,wmt.fm_intraoperation_step_type,fm_operation_seq_num,to_operation_seq_num
430: FROM
431: wip_move_transactions wmt,
432: wip_operations wop
433: WHERE
434: wop.wip_entity_id = wmt.wip_entity_id
435: AND wmt.organization_id = p_org_id
436: AND wop.organization_id = p_org_id

Line 494: wip_operations wop

490: AND (wmt.fm_intraoperation_step_type = WIP_CONSTANTS.REJECT
491: OR wmt.to_intraoperation_step_type = WIP_CONSTANTS.REJECT)
492: ) wmt_raw_shift_info
493: ) wmt,
494: wip_operations wop
495:
496: WHERE
497: wop.wip_entity_id = wmt.wip_entity_id
498: AND wop.organization_id = p_org_id

Line 552: wip_operations wop

548: wmt.transaction_date,
549: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id,null, wmt.transaction_date) as shift_info
550: FROM
551: wip_move_transactions wmt,
552: wip_operations wop
553: WHERE
554: wmt.transaction_date >= p_cutoff_date
555: AND wmt.organization_id = p_org_id
556: AND wop.organization_id = p_org_id

Line 584: wip_operations wop

580: OR (wop.operation_seq_num = wmt.fm_operation_seq_num
581: AND wmt.fm_intraoperation_step_type > WIP_CONSTANTS.RUN))))
582: ) pre_cal
583: ) post_cal,
584: wip_operations wop
585: WHERE
586: wop.wip_entity_id = post_cal.wip_entity_id
587: AND wop.organization_id = p_org_id
588: AND ((post_cal.fm_intraoperation_step_type = WIP_CONSTANTS.REJECT AND post_cal.fm_operation_seq_num = wop.operation_seq_num )

Line 2274: wip_operations wop

2270:
2271: /*
2272: SELECT wmt.transaction_date, wop.department_id into l_start_move_tran_date_to_calc, l_department_id
2273: FROM wip_move_transactions wmt,
2274: wip_operations wop
2275: WHERE
2276: wmt.creation_date >= l_last_calculation_date
2277: AND wmt.organization_id = p_org_id
2278: AND wop.organization_id = p_org_id