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_MOVE_VALIDATOR dependencies on WIP_REPETITIVE_SCHEDULES

Line 298: FROM wip_repetitive_schedules wrs1

294: -- derive the first transactable schedule if REPETITIVE_SCHEDULE_ID is null
295: UPDATE wip_move_txn_interface wmti
296: SET wmti.repetitive_schedule_id =
297: (SELECT wrs1.repetitive_schedule_id
298: FROM wip_repetitive_schedules wrs1
299: WHERE wrs1.wip_entity_id = wmti.wip_entity_id
300: AND wrs1.organization_id = wmti.organization_id
301: AND wrs1.line_id = wmti.line_id
302: AND wrs1.status_type IN (WIP_CONSTANTS.RELEASED,

Line 306: FROM wip_repetitive_schedules wrs2

302: AND wrs1.status_type IN (WIP_CONSTANTS.RELEASED,
303: WIP_CONSTANTS.COMP_CHRG)
304: AND wrs1.first_unit_start_date =
305: (SELECT MIN(wrs2.first_unit_start_date)
306: FROM wip_repetitive_schedules wrs2
307: WHERE wrs2.wip_entity_id = wmti.wip_entity_id
308: AND wrs2.organization_id = wmti.organization_id
309: AND wrs2.line_id = wmti.line_id
310: AND wrs2.status_type IN (WIP_CONSTANTS.RELEASED,

Line 377: FROM wip_repetitive_schedules wrs

373: AND wmti.process_status = WIP_CONSTANTS.RUNNING
374: AND ((wmti.entity_type = WIP_CONSTANTS.REPETITIVE
375: AND NOT EXISTS
376: (SELECT 'X'
377: FROM wip_repetitive_schedules wrs
378: WHERE wrs.wip_entity_id = wmti.wip_entity_id
379: AND wrs.organization_id = wmti.organization_id
380: AND wrs.line_id = wmti.line_id
381: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,

Line 546: FROM wip_repetitive_schedules wrs,

542: WIP_CONSTANTS.REVISION_CONTROLLED)
543: AND ((wmti.entity_type = WIP_CONSTANTS.REPETITIVE
544: AND NOT EXISTS
545: (SELECT 'X'
546: FROM wip_repetitive_schedules wrs,
547: mtl_item_revisions mir
548: WHERE wrs.organization_id = wmti.organization_id
549: AND wrs.repetitive_schedule_id = wmti.repetitive_schedule_id
550: AND mir.organization_id = wmti.organization_id

Line 771: FROM wip_repetitive_schedules wrs

767: AND wmti.process_status = WIP_CONSTANTS.RUNNING
768: AND ((wmti.entity_type = WIP_CONSTANTS.REPETITIVE
769: AND EXISTS
770: (SELECT 'X'
771: FROM wip_repetitive_schedules wrs
772: WHERE wrs.repetitive_schedule_id = wmti.repetitive_schedule_id
773: AND wrs.organization_id = wmti.organization_id
774: AND wrs.date_released > wmti.transaction_date))
775: OR

Line 829: FROM wip_repetitive_schedules wrs

825: WIP_CONSTANTS.LOTBASED)
826: OR (wmti.entity_type = WIP_CONSTANTS.REPETITIVE
827: AND repetitive_schedule_id IN
828: (SELECT wrs.repetitive_schedule_id
829: FROM wip_repetitive_schedules wrs
830: WHERE wrs.wip_entity_id = wmti.wip_entity_id
831: AND wrs.organization_id = wmti.organization_id
832: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,
833: WIP_CONSTANTS.COMP_CHRG))))))

Line 1682: FROM wip_repetitive_schedules wrs,

1678: wri.completion_subinventory subinv,
1679: wri.completion_locator_id locID,
1680: mp.negative_inv_receipt_code negative_allow,
1681: msik.concatenated_segments assembly_name
1682: FROM wip_repetitive_schedules wrs,
1683: wip_repetitive_items wri,
1684: mtl_system_items_kfv msik,
1685: mtl_parameters mp,
1686: wip_move_txn_interface wmti

Line 2550: FROM wip_repetitive_schedules wrs

2546: OR
2547: (wmti.entity_type = WIP_CONSTANTS.REPETITIVE AND
2548: wor.repetitive_schedule_id IN
2549: (SELECT wrs.repetitive_schedule_id
2550: FROM wip_repetitive_schedules wrs
2551: WHERE wrs.wip_entity_id = wmti.wip_entity_id
2552: AND wrs.organization_id = wmti.organization_id
2553: AND wrs.line_id = wmti.line_id
2554: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,

Line 2629: FROM wip_repetitive_schedules wrs

2625: OR
2626: (wmti.entity_type = WIP_CONSTANTS.REPETITIVE AND
2627: wor.repetitive_schedule_id IN
2628: (SELECT wrs.repetitive_schedule_id
2629: FROM wip_repetitive_schedules wrs
2630: WHERE wrs.organization_id = wmti.organization_id
2631: AND wrs.wip_entity_id = wmti.wip_entity_id
2632: AND wrs.line_id = wmti.line_id
2633: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,