APPS.WIP_PICKING_PVT dependencies on WIP_FLOW_SCHEDULES

Line 688: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs

684: a.bill_sequence_id,
685: wfs.primary_item_id,
686: wfs.SCHEDULED_COMPLETION_DATE,
687: wfs.planned_quantity
688: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs
689: where a.bill_sequence_id = b.common_bill_sequence_id
690: and b.assembly_item_id = wfs.primary_item_id
691: and wfs.wip_entity_id = v_wip_entity_id
692: and b.organization_id = wfs.organization_id

Line 1147: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs

1143: wfs.SCHEDULED_COMPLETION_DATE,
1144: wfs.planned_quantity
1145: into p_alloc_tbl(i).bill_org_id, p_alloc_tbl(i).bill_seq_id, l_itemID, l_abm,
1146: p_alloc_tbl(i).alt_rtg_dsg, l_reqDate, l_assemblyQty
1147: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs
1148: where a.bill_sequence_id = b.common_bill_sequence_id
1149: and b.assembly_item_id = wfs.primary_item_id
1150: and wfs.wip_entity_id = p_alloc_tbl(i).wip_entity_id
1151: and b.organization_id = wfs.organization_id

Line 1174: from bom_operational_routings a, bom_operational_routings b, wip_flow_schedules wfs

1170:
1171: begin
1172: select a.routing_sequence_id
1173: into l_routing_seq_id
1174: from bom_operational_routings a, bom_operational_routings b, wip_flow_schedules wfs
1175: where a.routing_sequence_id = b.common_routing_sequence_id
1176: and b.assembly_item_id = wfs.primary_item_id
1177: and wfs.wip_entity_id = p_alloc_tbl(i).wip_entity_id
1178: and b.organization_id = wfs.organization_id

Line 1287: from wip_flow_schedules

1283: end if; -- bug#3409239 End
1284: else -- if(p_alloc_tbl(i).bill_seq_id is null..
1285: select allocated_flag
1286: into l_dummy
1287: from wip_flow_schedules
1288: where wip_entity_id = p_alloc_tbl(i).wip_entity_id
1289: for update of allocated_flag nowait;
1290: end if;
1291: