DBA Data[Home] [Help]

APPS.BOM_BOM_COPYORG_IMP dependencies on MTL_PARAMETERS

Line 124: mtl_parameters org1,

120: NULL RowIdentifier,
121: to_char(bom.implementation_date,'YYYY-MM-DD HH24:MI:SS') ImplementationDate --Bug: 5174575: New attribute added for R12
122: FROM bom_bill_of_materials bom,
123: mtl_system_items_kfv item1,
124: mtl_parameters org1,
125: mtl_parameters org2,
126: mtl_system_items_kfv item2
127: WHERE org1.organization_id = bom.organization_id
128: AND item1.organization_id = bom.organization_id

Line 125: mtl_parameters org2,

121: to_char(bom.implementation_date,'YYYY-MM-DD HH24:MI:SS') ImplementationDate --Bug: 5174575: New attribute added for R12
122: FROM bom_bill_of_materials bom,
123: mtl_system_items_kfv item1,
124: mtl_parameters org1,
125: mtl_parameters org2,
126: mtl_system_items_kfv item2
127: WHERE org1.organization_id = bom.organization_id
128: AND item1.organization_id = bom.organization_id
129: AND item1.inventory_item_id = bom.assembly_item_id

Line 200: mtl_parameters org,

196: comp.unit_price UnitPrice,
197: comp.basis_type BasisType --Bug: 5174575: New attribute added for R12
198: FROM bom_inventory_components comp,
199: mtl_system_items_kfv item1,
200: mtl_parameters org,
201: bom_bill_of_materials bom,
202: mtl_system_items_kfv item2
203: WHERE bom.bill_sequence_id = comp.bill_sequence_id
204: AND org.organization_id = bom.organization_id

Line 248: mtl_parameters org,

244: 'CREATE' TransactionType,
245: NULL RowIdentifier
246: FROM bom_substitute_components sub,
247: mtl_system_items_kfv item1,
248: mtl_parameters org,
249: bom_bill_of_materials bom,
250: bom_inventory_components comp,
251: mtl_system_items_kfv item2,
252: mtl_system_items_kfv item3

Line 299: mtl_parameters org,

295: 'CREATE' TransactionType,
296: NULL RowIdentifier
297: FROM bom_reference_designators ref,
298: mtl_system_items_kfv item1,
299: mtl_parameters org,
300: bom_inventory_components comp,
301: mtl_system_items_kfv item2,
302: bom_bill_of_materials bom
303: WHERE comp.component_sequence_id = ref.component_sequence_id

Line 346: mtl_parameters org,

342: 'CREATE' TransactionType,
343: NULL RowIdentifier
344: FROM bom_component_operations comp_oper,
345: mtl_system_items_kfv item1,
346: mtl_parameters org,
347: bom_inventory_components comp,
348: mtl_system_items_kfv item2,
349: bom_bill_of_materials bom
350: WHERE comp.component_sequence_id = comp_oper.component_sequence_id