DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2662: FROM WIP_REQUIREMENT_OPERATIONS wro

2658: FROM WIP_DISCRETE_JOBS wdj
2659: WHERE (wdj.status_type <> 1
2660: OR
2661: NOT EXISTS(SELECT NULL
2662: FROM WIP_REQUIREMENT_OPERATIONS wro
2663: WHERE (wro.operation_seq_num = p_operation_seq_num
2664: OR p_operation_seq_num = 1)
2665: AND wro.inventory_item_id = p_rev_comp_item_id
2666: AND wro.wip_entity_id = wdj.wip_entity_id)

Line 2689: FROM WIP_REQUIREMENT_OPERATIONS wro

2685: , WIP_ENTITIES we2
2686: WHERE (wdj.status_type <> 1
2687: OR
2688: NOT EXISTS (SELECT NULL
2689: FROM WIP_REQUIREMENT_OPERATIONS wro
2690: WHERE (wro.operation_seq_num = p_operation_seq_num
2691: OR p_operation_seq_num = 1)
2692: AND wro.inventory_item_id = p_rev_comp_item_id
2693: AND wro.wip_entity_id = wdj.wip_entity_id)

Line 2715: FROM WIP_REQUIREMENT_OPERATIONS wro

2711: FROM WIP_DISCRETE_JOBS wdj
2712: WHERE (wdj.status_type <> 1
2713: OR
2714: NOT EXISTS(SELECT NULL
2715: FROM WIP_REQUIREMENT_OPERATIONS wro
2716: WHERE (wro.operation_seq_num = p_operation_seq_num
2717: OR p_operation_seq_num = 1)
2718: AND wro.inventory_item_id = p_rev_comp_item_id
2719: AND wro.wip_entity_id = wdj.wip_entity_id)