APPS.BOM_DIAGUNITTEST_BILLHLCHK dependencies on MTL_PARAMETERS

Line 74: from mtl_parameters

70:
71: If l_org_id is not null Then /* validate if input org_id exists*/
72: Begin
73: select 1 into l_org_exists
74: from mtl_parameters
75: where organization_id=l_org_id;
76: Exception
77: When others Then
78: l_org_exists :=0;

Line 133: ' mtl_parameters mp '||

129: ' bsb.bill_sequence_id "Bill Sequence Id", '||
130: ' bcb.component_sequence_id "Component Sequence Id" '||
131: ' from bom_components_b bcb, bom_structures_b bsb, '||
132: ' mtl_item_flexfields mif1, mtl_item_flexfields mif2, '||
133: ' mtl_parameters mp '||
134: ' where bsb.bill_sequence_id = bcb.bill_sequence_id '||
135: ' and bsb.assembly_item_id = mif1.inventory_item_id '||
136: ' and bsb.organization_id = mif1.organization_id '||
137: ' and bcb.component_item_id = mif2.inventory_item_id '||

Line 181: ' mtl_parameters mp '||

177: ' bsb.bill_sequence_id "Bill Sequence Id", '||
178: ' bcb.component_sequence_id "Component Sequence Id" '||
179: ' from bom_components_b bcb, bom_structures_b bsb, '||
180: ' mtl_item_flexfields mif1, mtl_item_flexfields mif2, '||
181: ' mtl_parameters mp '||
182: ' where bsb.bill_sequence_id = bcb.bill_sequence_id '||
183: ' and bsb.assembly_item_id = mif1.inventory_item_id '||
184: ' and bsb.organization_id = mif1.organization_id '||
185: ' and bcb.component_item_id = mif2.inventory_item_id '||

Line 230: ' mtl_parameters mp '||

226: ' bsb.bill_sequence_id "Bill Sequence Id", '||
227: ' bcb.component_sequence_id "Component Sequence Id" '||
228: ' from bom_components_b bcb, bom_structures_b bsb, '||
229: ' mtl_item_flexfields mif1, mtl_item_flexfields mif2, '||
230: ' mtl_parameters mp '||
231: ' where bsb.bill_sequence_id = bcb.bill_sequence_id '||
232: ' and bsb.assembly_item_id = mif1.inventory_item_id '||
233: ' and bsb.organization_id = mif1.organization_id '||
234: ' and bcb.component_item_id = mif2.inventory_item_id '||

Line 319: ' from bom_structures_b bsb, mtl_item_flexfields mif, mtl_parameters mp '||

315: ' bsb.assembly_item_id "Assembly Item Id" , '||
316: ' bsb.organization_id "Organization Id", '||
317: ' bsb.bill_sequence_id "Bill Sequence Id", '||
318: ' bsb.common_bill_sequence_id "Common Bill Sequence Id" '||
319: ' from bom_structures_b bsb, mtl_item_flexfields mif, mtl_parameters mp '||
320: ' where mif.inventory_item_id = bsb.assembly_item_id '||
321: ' and mif.organization_id = bsb.organization_id '||
322: ' and bsb.organization_id = mp.organization_id '||
323: ' and bsb.implementation_date is null ';