APPS.WIP_PICKING_PVT dependencies on WIP_OPERATION_RESOURCES

Line 2646: from bom_resources br1, wip_operation_resources wor1

2642:
2643: begin
2644: select br1.supply_subinventory, br1.supply_locator_id
2645: into l_supply_subinventory, l_supply_locator_id
2646: from bom_resources br1, wip_operation_resources wor1
2647: where br1.resource_id = wor1.resource_id
2648: and br1.organization_id = wor1.organization_id
2649: and wor1.wip_entity_id = p_wip_entity_id
2650: and wor1.organization_id = p_org_id

Line 2654: from bom_resources br2, wip_operation_resources wor2

2650: and wor1.organization_id = p_org_id
2651: and wor1.operation_seq_num = l_operation_seq_num
2652: and wor1.resource_seq_num =
2653: (select min(wor2.resource_seq_num)
2654: from bom_resources br2, wip_operation_resources wor2
2655: where wor2.wip_entity_id = wor1.wip_entity_id
2656: and wor2.organization_id= wor1.organization_id
2657: and wor2.operation_seq_num = wor1.operation_seq_num
2658: and br2.supply_subinventory is not null

Line 2692: from bom_resources br1, wip_operation_resources wor1

2688:
2689: begin
2690: select br1.supply_subinventory, br1.supply_locator_id
2691: into l_supply_subinventory, l_supply_locator_id
2692: from bom_resources br1, wip_operation_resources wor1
2693: where br1.resource_id = wor1.resource_id
2694: and br1.organization_id = wor1.organization_id
2695: and wor1.wip_entity_id = p_wip_entity_id
2696: and wor1.repetitive_schedule_id = p_repetitive_schedule_id

Line 2701: from bom_resources br2, wip_operation_resources wor2

2697: and wor1.organization_id = p_org_id
2698: and wor1.operation_seq_num = l_operation_seq_num
2699: and wor1.resource_seq_num =
2700: (select min(wor2.resource_seq_num)
2701: from bom_resources br2, wip_operation_resources wor2
2702: where wor2.wip_entity_id = wor1.wip_entity_id
2703: and wor2.organization_id= wor1.organization_id
2704: and wor2.operation_seq_num = wor1.operation_seq_num
2705: and br2.supply_subinventory is not null