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_MOVE_TRANSACTIONS

Line 185: wip_move_transactions wmt

181: SELECT
182: wip_ws_embedded_analytics_pk.get_shift_info(wmt.organization_id, wmt.transaction_date) as shift_info,
183: wmt.*
184: FROM
185: wip_move_transactions wmt
186: WHERE
187: wmt.transaction_date > p_cutoff_date
188: AND wmt.organization_id = p_org_id
189: )

Line 316: wip_move_transactions wmt,

312: wmt.primary_quantity,
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

Line 388: wip_move_transactions wmt

384: to_intraoperation_step_type,
385: fm_operation_seq_num,
386: fm_intraoperation_step_type
387: FROM
388: wip_move_transactions wmt
389: WHERE
390: transaction_date >= p_cutoff_date
391: AND wmt.organization_id = p_org_id
392: AND (wmt.fm_intraoperation_step_type = WIP_CONSTANTS.SCRAP

Line 431: wip_move_transactions wmt,

427: case when (wmt.TO_DEPARTMENT_ID =WIP_CONSTANTS.SCRAP AND wop.operation_seq_num = wmt.fm_operation_seq_num) then wmt.to_department_id else wmt.fm_department_id end),wmt.transaction_date) as shift_info,
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

Line 486: wip_move_transactions wmt

482: ,(case when wmt.to_intraoperation_step_type = WIP_CONSTANTS.REJECT then wmt.to_department_id else wmt.fm_department_id end)
483: ,wmt.transaction_date) as shift_info ,
484: wmt.*
485: FROM
486: wip_move_transactions wmt
487: WHERE
488: transaction_date > p_cutoff_date
489: AND wmt.organization_id = p_org_id
490: AND (wmt.fm_intraoperation_step_type = WIP_CONSTANTS.REJECT

Line 551: wip_move_transactions wmt,

547: wmt.primary_quantity,
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

Line 2266: FROM wip_move_transactions

2262:
2263: l_department_id := NULL;
2264:
2265: SELECT transaction_date INTO l_start_move_tran_date_to_calc
2266: FROM wip_move_transactions
2267: WHERE creation_date >= l_last_calculation_date
2268: AND organization_id = p_org_id
2269: AND ROWNUM = 1;
2270:

Line 2273: FROM wip_move_transactions wmt,

2269: AND ROWNUM = 1;
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