APPS.AMS_BOM_PVT dependencies on BOM_BILL_OF_MATERIALS

Line 66: FROM bom_bill_of_materials bo

62: l_org_id IN NUMBER
63: )
64: IS
65: SELECT DISTINCT 'Y'
66: FROM bom_bill_of_materials bo
67: WHERE bo.assembly_item_id = l_item_id
68: AND bo.organization_id = l_org_id;
69:
70:

Line 79: bom_bill_of_materials bo

75: l_comp_id IN VARCHAR2)
76: IS
77: SELECT 'Y'
78: FROM bom_inventory_components bc,
79: bom_bill_of_materials bo
80: WHERE bc.bill_sequence_id = bo.bill_sequence_id
81: AND bo.assembly_item_id = l_item_id
82: AND bo.organization_id = l_org_id
83: AND bc.component_item_id = l_comp_id;

Line 92: bom_bill_of_materials bo

88: l_org_id IN NUMBER)
89: IS
90: SELECT count(1)
91: FROM bom_inventory_components bc,
92: bom_bill_of_materials bo
93: WHERE bc.bill_sequence_id = bo.bill_sequence_id
94: AND bo.assembly_item_id = l_item_id
95: AND bo.organization_id = l_org_id;
96:

Line 251: bom_bill_of_materials bo

247: IS
248: SELECT DISTINCT bc.last_update_date,
249: bc.last_updated_by
250: FROM bom_inventory_components bc,
251: bom_bill_of_materials bo
252: -- , mtl_system_items_b i
253: -- fixed bug 3631360
254: WHERE bc.bill_sequence_id = bo.bill_sequence_id
255: AND bo.assembly_item_id = l_item_id

Line 269: bom_bill_of_materials bo

265: org_id IN NUMBER )
266: IS
267: SELECT max(bc.item_num)
268: FROM bom_inventory_components bc,
269: bom_bill_of_materials bo
270: WHERE bc.bill_sequence_id = bo.bill_sequence_id
271: AND bo.assembly_item_id = item_id
272: AND bo.organization_id = org_id;
273:

Line 280: , bom_bill_of_materials bo

276: l_header_segment VARCHAR)
277: IS SELECT DISTINCT trunc(b.effectivity_date)
278: FROM bom_inventory_components b
279: , mtl_system_items_b inv
280: , bom_bill_of_materials bo
281: WHERE b.component_item_id = l_comp_inv_id
282: AND b.bill_Sequence_id = bo.bill_Sequence_id
283: AND inv.segment1 =l_header_segment
284: AND bo.assembly_item_id = inv.inventory_item_id;

Line 292: , bom_bill_of_materials bo

288: ,l_org_id NUMBER)
289: IS SELECT DISTINCT b.effectivity_date
290: -- BUG 2993951 FIX:: trunc(b.effectivity_date)
291: FROM bom_inventory_components b
292: , bom_bill_of_materials bo
293: WHERE b.component_item_id = l_comp_inv_id
294: AND b.bill_Sequence_id = bo.bill_Sequence_id
295: AND bo.assembly_item_id =l_assembly_item_id
296: AND bo.ALTERNATE_BOM_DESIGNATOR is null