[Home] [Help]
74: l_org_id IN NUMBER,
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
87: CURSOR count_of_comp( l_item_id IN NUMBER,
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;
246: l_comp_id IN VARCHAR )
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
264: CURSOR getSequence( item_id IN NUMBER,
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;
274: /*
275: CURSOR get_effectivity_date(l_comp_inv_id NUMBER,
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
287: ,l_assembly_item_id NUMBER
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