APPS.WIP_PICKING_PVT dependencies on WIP_FLOW_SCHEDULES

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

706: a.bill_sequence_id,
707: wfs.primary_item_id,
708: wfs.SCHEDULED_COMPLETION_DATE,
709: wfs.planned_quantity
710: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs
711: where a.bill_sequence_id = b.common_bill_sequence_id
712: and b.assembly_item_id = wfs.primary_item_id
713: and wfs.wip_entity_id = v_wip_entity_id
714: and b.organization_id = wfs.organization_id

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

1168: wfs.SCHEDULED_COMPLETION_DATE,
1169: wfs.planned_quantity
1170: into p_alloc_tbl(i).bill_org_id, p_alloc_tbl(i).bill_seq_id, l_itemID, l_abm,
1171: p_alloc_tbl(i).alt_rtg_dsg, l_reqDate, l_assemblyQty
1172: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs
1173: where a.bill_sequence_id = b.common_bill_sequence_id
1174: and b.assembly_item_id = wfs.primary_item_id
1175: and wfs.wip_entity_id = p_alloc_tbl(i).wip_entity_id
1176: and b.organization_id = wfs.organization_id

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

1195:
1196: begin
1197: select a.routing_sequence_id
1198: into l_routing_seq_id
1199: from bom_operational_routings a, bom_operational_routings b, wip_flow_schedules wfs
1200: where a.routing_sequence_id = b.common_routing_sequence_id
1201: and b.assembly_item_id = wfs.primary_item_id
1202: and wfs.wip_entity_id = p_alloc_tbl(i).wip_entity_id
1203: and b.organization_id = wfs.organization_id

Line 1312: from wip_flow_schedules

1308: end if; -- bug#3409239 End
1309: else -- if(p_alloc_tbl(i).bill_seq_id is null..
1310: select allocated_flag
1311: into l_dummy
1312: from wip_flow_schedules
1313: where wip_entity_id = p_alloc_tbl(i).wip_entity_id
1314: for update of allocated_flag nowait;
1315: end if;
1316: