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.INV_UI_RCV_LOVS dependencies on MTL_RELATED_ITEMS

Line 1594: mtl_related_items mri ,

1590: (
1591: SELECT
1592: 'Valid PO Shipments'
1593: FROM po_lines_all pl ,
1594: mtl_related_items mri ,
1595: mtl_system_items_kfv msi ,
1596: po_line_locations_all poll
1597: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1598: , mtl_parameters mp,

Line 1727: mtl_related_items mri ,

1723: to_char(poh.org_id) FIELD14 --
1724: FROM po_headers poh,
1725: fnd_lookup_values_vl flv ,
1726: po_lines_all pl ,
1727: mtl_related_items mri ,
1728: mtl_system_items_kfv msi ,
1729: po_line_locations_all poll
1730: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1731: , mtl_parameters mp,

Line 1789: mtl_related_items mri ,

1785: to_char(poh.org_id) FIELD14 --
1786: FROM po_headers poh,
1787: fnd_lookup_values_vl flv ,
1788: po_lines_all pl ,
1789: mtl_related_items mri ,
1790: mtl_system_items_kfv msi ,
1791: po_line_locations_all poll
1792: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1793: , mtl_parameters mp,

Line 2479: mtl_related_items mri ,

2475: (
2476: SELECT
2477: 'Valid PO Shipments'
2478: FROM po_lines_all pl ,
2479: mtl_related_items mri ,
2480: mtl_system_items_kfv msi ,
2481: po_line_locations_all poll
2482: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2483: , mtl_parameters mp,

Line 2950: , mtl_related_items mri

2946: uom_code
2947: from po_lines_all pl
2948: , mtl_units_of_measure mum
2949: , mtl_system_items_vl msi
2950: , mtl_related_items mri
2951: where msi.organization_id = p_organization_id -- Bug 6437363
2952: and msi.inventory_item_id = p_inventory_item_id -- Bug 6311550
2953: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
2954: and pl.po_header_id = p_po_header_id

Line 2980: from MTL_RELATED_ITEMS MRI

2976: -- End for Bug 7440217
2977: )
2978: AND pl.line_num LIKE (po_line_number)
2979: AND exists (select 'c' -- Bug 6437363
2980: from MTL_RELATED_ITEMS MRI
2981: where MRI.RELATED_ITEM_ID = MSI.INVENTORY_ITEM_ID
2982: AND PL.ITEM_ID = MRI.INVENTORY_ITEM_ID
2983: union all
2984: select 'c'

Line 2985: from MTL_RELATED_ITEMS MRI

2981: where MRI.RELATED_ITEM_ID = MSI.INVENTORY_ITEM_ID
2982: AND PL.ITEM_ID = MRI.INVENTORY_ITEM_ID
2983: union all
2984: select 'c'
2985: from MTL_RELATED_ITEMS MRI
2986: where MRI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
2987: AND PL.ITEM_ID = MRI.RELATED_ITEM_ID
2988: AND MRI.RECIPROCAL_FLAG = 'Y' )
2989: order by 1;

Line 3376: ,mtl_related_items mri

3372: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3373: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3374: msi.stock_enabled_flag
3375: from po_lines_all pol
3376: ,mtl_related_items mri
3377: ,mtl_system_items_vl msi /* Bug 5581528 */
3378: /*,mtl_system_items_kfv msia */ /* Bug 6334679*/
3379: where msi.organization_id = p_organization_id
3380: and msi.concatenated_segments like p_concatenated_segments

Line 3837: ,mtl_related_items mri

3833: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3834: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3835: msi.stock_enabled_flag
3836: from po_lines_all pol
3837: ,mtl_related_items mri
3838: ,mtl_system_items_vl msi /* Bug 5581528 */
3839: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
3840: where msi.organization_id = p_organization_id
3841: and msi.concatenated_segments like p_concatenated_segments

Line 4309: ,mtl_related_items mri

4305: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4306: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4307: msi.stock_enabled_flag
4308: from po_lines_all pol
4309: ,mtl_related_items mri
4310: ,mtl_system_items_vl msi /* Bug 5581528 */
4311: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
4312: where msi.organization_id = p_organization_id
4313: and msi.concatenated_segments like p_concatenated_segments

Line 4770: ,mtl_related_items mri

4766: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4767: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4768: msi.stock_enabled_flag
4769: from po_lines_all pol
4770: ,mtl_related_items mri
4771: ,mtl_system_items_vl msi /* Bug 5581528 */
4772: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
4773: where msi.organization_id = p_organization_id
4774: and msi.concatenated_segments like p_concatenated_segments

Line 5194: ,mtl_related_items mri

5190: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5191: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5192: msi.stock_enabled_flag
5193: from po_lines_all pol
5194: ,mtl_related_items mri
5195: ,mtl_system_items_vl msi /* Bug 5581528 */
5196: /*,mtl_system_items_kfv msia*/ /* Bug 6334679 */
5197: where msi.organization_id = p_organization_id
5198: and msi.concatenated_segments like p_concatenated_segments

Line 5613: ,mtl_related_items mri

5609: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5610: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5611: msi.stock_enabled_flag
5612: from po_lines_all pol
5613: ,mtl_related_items mri
5614: ,mtl_system_items_vl msi /* Bug 5581528 */
5615: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
5616: where msi.organization_id = p_organization_id
5617: and msi.concatenated_segments like p_concatenated_segments

Line 6918: mtl_related_items mri,

6914: AND msi.concatenated_segments LIKE p_concatenated_segments
6915: AND (msi.purchasing_enabled_flag = 'Y' OR msi.stock_enabled_flag = 'Y')
6916: AND EXISTS (SELECT '1'
6917: FROM po_lines_all pol,
6918: mtl_related_items mri,
6919: po_line_locations_all pll
6920: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6921: , mtl_parameters mp,
6922: rcv_parameters rp