DBA Data[Home] [Help]

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 1683: wip_repetitive_items wri,

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