APPS.WIP_PICKING_PVT dependencies on BOM_RESOURCES

Line 2751: from bom_resources br1, wip_operation_resources wor1

2747:
2748: begin
2749: select br1.supply_subinventory, br1.supply_locator_id
2750: into l_supply_subinventory, l_supply_locator_id
2751: from bom_resources br1, wip_operation_resources wor1
2752: where br1.resource_id = wor1.resource_id
2753: and br1.organization_id = wor1.organization_id
2754: and wor1.wip_entity_id = p_wip_entity_id
2755: and wor1.organization_id = p_org_id

Line 2759: from bom_resources br2, wip_operation_resources wor2

2755: and wor1.organization_id = p_org_id
2756: and wor1.operation_seq_num = l_operation_seq_num
2757: and wor1.resource_seq_num =
2758: (select min(wor2.resource_seq_num)
2759: from bom_resources br2, wip_operation_resources wor2
2760: where wor2.wip_entity_id = wor1.wip_entity_id
2761: and wor2.organization_id= wor1.organization_id
2762: and wor2.operation_seq_num = wor1.operation_seq_num
2763: and br2.supply_subinventory is not null

Line 2797: from bom_resources br1, wip_operation_resources wor1

2793:
2794: begin
2795: select br1.supply_subinventory, br1.supply_locator_id
2796: into l_supply_subinventory, l_supply_locator_id
2797: from bom_resources br1, wip_operation_resources wor1
2798: where br1.resource_id = wor1.resource_id
2799: and br1.organization_id = wor1.organization_id
2800: and wor1.wip_entity_id = p_wip_entity_id
2801: and wor1.repetitive_schedule_id = p_repetitive_schedule_id

Line 2806: from bom_resources br2, wip_operation_resources wor2

2802: and wor1.organization_id = p_org_id
2803: and wor1.operation_seq_num = l_operation_seq_num
2804: and wor1.resource_seq_num =
2805: (select min(wor2.resource_seq_num)
2806: from bom_resources br2, wip_operation_resources wor2
2807: where wor2.wip_entity_id = wor1.wip_entity_id
2808: and wor2.organization_id= wor1.organization_id
2809: and wor2.operation_seq_num = wor1.operation_seq_num
2810: and br2.supply_subinventory is not null