eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_BOM_COPYORG_IMP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 123: mtl_system_items_kfv item1,

119: NULL DGDescription,
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

Line 126: mtl_system_items_kfv item2

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
130: AND org2.organization_id(+) = bom.common_organization_id

Line 199: mtl_system_items_kfv item1,

195: comp.suggested_vendor_name SuggestedVendorName,
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

Line 202: mtl_system_items_kfv item2

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
205: AND item1.organization_id = bom.organization_id
206: AND item1.inventory_item_id = bom.assembly_item_id

Line 247: mtl_system_items_kfv item1,

243: NULL ReturnStatus,
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,

Line 251: mtl_system_items_kfv item2,

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
253: WHERE comp.component_sequence_id = sub.component_sequence_id
254: AND bom.bill_sequence_id = comp.bill_sequence_id
255: AND org.organization_id = bom.organization_id

Line 252: mtl_system_items_kfv item3

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
253: WHERE comp.component_sequence_id = sub.component_sequence_id
254: AND bom.bill_sequence_id = comp.bill_sequence_id
255: AND org.organization_id = bom.organization_id
256: AND item1.inventory_item_id = bom.assembly_item_id

Line 298: mtl_system_items_kfv item1,

294: NULL ReturnStatus,
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

Line 301: mtl_system_items_kfv item2,

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
304: AND bom.bill_sequence_id = comp.bill_sequence_id
305: AND org.organization_id = bom.organization_id

Line 345: mtl_system_items_kfv item1,

341: NULL ReturnStatus,
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

Line 348: mtl_system_items_kfv item2,

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
351: AND bom.bill_sequence_id = comp.bill_sequence_id
352: AND org.organization_id = bom.organization_id