APPS.WIP_PICKING_PVT dependencies on BOM_BILL_OF_MATERIALS

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 718: from bom_bill_of_materials c

714: and b.organization_id = wfs.organization_id
715: and ( nvl(b.alternate_bom_designator, 'none') = nvl(wfs.alternate_bom_designator, 'none')
716: or ( b.alternate_bom_designator IS NULL
717: and not exists(select 'x'
718: from bom_bill_of_materials c
719: where c.assembly_item_id = wfs.primary_item_id
720: and c.organization_id = wfs.organization_id
721: and c.alternate_bom_designator = wfs.alternate_bom_designator
722: )

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 1180: from bom_bill_of_materials c

1176: and b.organization_id = wfs.organization_id
1177: and ( nvl(b.alternate_bom_designator, 'none') = nvl(wfs.alternate_bom_designator, 'none')
1178: or ( b.alternate_bom_designator IS NULL
1179: and not exists(select 'x'
1180: from bom_bill_of_materials c
1181: where c.assembly_item_id = wfs.primary_item_id
1182: and c.organization_id = wfs.organization_id
1183: and c.alternate_bom_designator = wfs.alternate_bom_designator
1184: )