DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2670: FROM WIP_REQUIREMENT_OPERATIONS wro

2666: FROM WIP_DISCRETE_JOBS wdj
2667: WHERE (wdj.status_type <> 1
2668: OR
2669: NOT EXISTS(SELECT NULL
2670: FROM WIP_REQUIREMENT_OPERATIONS wro
2671: WHERE (wro.operation_seq_num = p_operation_seq_num
2672: OR p_operation_seq_num = 1)
2673: AND wro.inventory_item_id = p_rev_comp_item_id
2674: AND wro.wip_entity_id = wdj.wip_entity_id)

Line 2697: FROM WIP_REQUIREMENT_OPERATIONS wro

2693: , WIP_ENTITIES we2
2694: WHERE (wdj.status_type <> 1
2695: OR
2696: NOT EXISTS (SELECT NULL
2697: FROM WIP_REQUIREMENT_OPERATIONS wro
2698: WHERE (wro.operation_seq_num = p_operation_seq_num
2699: OR p_operation_seq_num = 1)
2700: AND wro.inventory_item_id = p_rev_comp_item_id
2701: AND wro.wip_entity_id = wdj.wip_entity_id)

Line 2723: FROM WIP_REQUIREMENT_OPERATIONS wro

2719: FROM WIP_DISCRETE_JOBS wdj
2720: WHERE (wdj.status_type <> 1
2721: OR
2722: NOT EXISTS(SELECT NULL
2723: FROM WIP_REQUIREMENT_OPERATIONS wro
2724: WHERE (wro.operation_seq_num = p_operation_seq_num
2725: OR p_operation_seq_num = 1)
2726: AND wro.inventory_item_id = p_rev_comp_item_id
2727: AND wro.wip_entity_id = wdj.wip_entity_id)