APPS.WIP_MOVE_VALIDATOR dependencies on WIP_REPETITIVE_ITEMS

Line 505: FROM wip_repetitive_items wri

501: WIP_CONSTANTS.RET_TXN)
502: AND ((wmti.entity_type = WIP_CONSTANTS.REPETITIVE
503: AND EXISTS
504: (SELECT 'X'
505: FROM wip_repetitive_items wri
506: WHERE wri.wip_entity_id = wmti.wip_entity_id
507: AND wri.organization_id = wmti.organization_id
508: AND wri.line_id = wmti.line_id
509: AND wri.completion_subinventory IS NULL))

Line 1615: wip_repetitive_items wri,

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
1619: WHERE wmti.primary_item_id = msik.inventory_item_id