DBA Data[Home] [Help]

APPS.ENG_VALIDATE dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1520: FROM WIP_REQUIREMENT_OPERATIONS wro

1516: FROM WIP_DISCRETE_JOBS wdj
1517: WHERE (wdj.status_type <> 1
1518: OR
1519: NOT EXISTS(SELECT NULL
1520: FROM WIP_REQUIREMENT_OPERATIONS wro
1521: WHERE wro.operation_seq_num = p_operation_seq_num
1522: AND wro.inventory_item_id = p_rev_comp_item_id
1523: AND wro.wip_entity_id = wdj.wip_entity_id)
1524: )

Line 1544: FROM WIP_REQUIREMENT_OPERATIONS wro

1540: , WIP_ENTITIES we2
1541: WHERE (wdj.status_type <> 1
1542: OR
1543: NOT EXISTS (SELECT NULL
1544: FROM WIP_REQUIREMENT_OPERATIONS wro
1545: WHERE wro.operation_seq_num = p_operation_seq_num
1546: AND wro.inventory_item_id = p_rev_comp_item_id
1547: AND wro.wip_entity_id = wdj.wip_entity_id)
1548: )

Line 1567: FROM WIP_REQUIREMENT_OPERATIONS wro

1563: FROM WIP_DISCRETE_JOBS wdj
1564: WHERE (wdj.status_type <> 1
1565: OR
1566: NOT EXISTS(SELECT NULL
1567: FROM WIP_REQUIREMENT_OPERATIONS wro
1568: WHERE wro.operation_seq_num = p_operation_seq_num
1569: AND wro.inventory_item_id = p_rev_comp_item_id
1570: AND wro.wip_entity_id = wdj.wip_entity_id)
1571: )