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 1614: FROM wip_repetitive_schedules wrs,

1610: wri.completion_subinventory subinv,
1611: wri.completion_locator_id locID,
1612: mp.negative_inv_receipt_code negative_allow,
1613: msik.concatenated_segments assembly_name
1614: FROM wip_repetitive_schedules wrs,
1615: wip_repetitive_items wri,
1616: mtl_system_items_kfv msik,
1617: mtl_parameters mp,
1618: wip_move_txn_interface wmti

Line 2482: FROM wip_repetitive_schedules wrs

2478: OR
2479: (wmti.entity_type = WIP_CONSTANTS.REPETITIVE AND
2480: wor.repetitive_schedule_id IN
2481: (SELECT wrs.repetitive_schedule_id
2482: FROM wip_repetitive_schedules wrs
2483: WHERE wrs.wip_entity_id = wmti.wip_entity_id
2484: AND wrs.organization_id = wmti.organization_id
2485: AND wrs.line_id = wmti.line_id
2486: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,

Line 2561: FROM wip_repetitive_schedules wrs

2557: OR
2558: (wmti.entity_type = WIP_CONSTANTS.REPETITIVE AND
2559: wor.repetitive_schedule_id IN
2560: (SELECT wrs.repetitive_schedule_id
2561: FROM wip_repetitive_schedules wrs
2562: WHERE wrs.organization_id = wmti.organization_id
2563: AND wrs.wip_entity_id = wmti.wip_entity_id
2564: AND wrs.line_id = wmti.line_id
2565: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,