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_UNITS_OF_MEASURE

Line 461: , mtl_units_of_measure mum

457: pl.Item_Id)
458: uom_code
459: FROM rcv_supply rsup
460: -- bug 2805640
461: , mtl_units_of_measure mum
462: , po_lines_all pl
463: , mtl_system_items_vl msi
464: WHERE rsup.po_line_id = pl.po_line_id
465: -- bug 2805640

Line 1331: from mtl_units_of_measure muom

1327: Begin
1328:
1329: select uom_class
1330: into p_primary_uom_class
1331: from mtl_units_of_measure muom
1332: where muom.uom_code = p_primary_uom_code;
1333:
1334: Exception
1335: When others then p_primary_uom_class := '';

Line 1350: mtl_units_of_measure muom

1346: , ''
1347: , muc.uom_class uom_class
1348: from
1349: mtl_uom_conversions_val_v muc ,
1350: mtl_units_of_measure muom
1351: where muc.uom_class = p_primary_uom_class
1352: and muc.item_id = 0
1353: and nvl(muc.disable_date,sysdate+1)>sysdate
1354: and muc.unit_of_measure = muom.unit_of_measure

Line 1359: --FROM mtl_units_of_measure

1355: and nvl(muom.disable_date,sysdate+1) > sysdate
1356: and muom.uom_code like (l_code)
1357: order by muc.unit_of_measure;
1358:
1359: --FROM mtl_units_of_measure
1360: --WHERE base_uom_flag = 'Y'
1361: --AND uom_code LIKE (p_uom_code || '%')
1362: --ORDER BY Upper(uom_code);
1363:

Line 1461: b. Removed the tables mtl_system_items_kfv and mtl_units_of_measure which are

1457: The following changes have been done while selecting Purchase Orders.
1458: i.e. doc type of PO.
1459: a. In the condition, "AND NVL(poll.approved_flag,'N') = 'Y' " ,
1460: nvl() has been removed.
1461: b. Removed the tables mtl_system_items_kfv and mtl_units_of_measure which are
1462: joined with po_lines_all table through outer join.
1463: c. Added the hint " +index(POH PO_HEADERS_U2) " to use the index PO_HEADERS_U2.
1464: d. Removed the Distinct clause from the select statement.
1465: */

Line 2904: , mtl_units_of_measure mum

2900: p_organization_id,
2901: pl.Item_Id)
2902: uom_code
2903: from po_lines_all pl
2904: , mtl_units_of_measure mum
2905: , mtl_system_items_vl msi
2906: where pl.item_id = msi.inventory_item_id (+)
2907: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
2908: and msi.organization_id = p_organization_id -- Bug 6437363

Line 2948: , mtl_units_of_measure mum

2944: p_organization_id,
2945: pl.Item_Id)
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

Line 3005: , mtl_units_of_measure mum

3001: p_organization_id,
3002: pl.Item_Id)
3003: uom_code
3004: FROM rcv_supply rsup
3005: , mtl_units_of_measure mum
3006: , po_lines_all pl
3007: , mtl_system_items_vl msi
3008: WHERE rsup.po_line_id = pl.po_line_id
3009: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE

Line 3558: , mtl_units_of_measure mum

3554: 0,
3555: 0,
3556: 'N'
3557: from po_lines_all pol
3558: , mtl_units_of_measure mum
3559: -- Bug 2619063, 2614016
3560: -- Modified to select the base uom for the uom class defined on po.
3561: where mum.uom_class = (SELECT mum2.uom_class
3562: FROM mtl_units_of_measure mum2

Line 3562: FROM mtl_units_of_measure mum2

3558: , mtl_units_of_measure mum
3559: -- Bug 2619063, 2614016
3560: -- Modified to select the base uom for the uom class defined on po.
3561: where mum.uom_class = (SELECT mum2.uom_class
3562: FROM mtl_units_of_measure mum2
3563: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
3564: and mum.base_uom_flag = 'Y'
3565: and pol.ITEM_ID is null
3566: and pol.item_description is not null

Line 4021: , mtl_units_of_measure mum

4017: 0,
4018: 0,
4019: 'N'
4020: from po_lines_all pol
4021: , mtl_units_of_measure mum
4022: -- Bug 2619063, 2614016
4023: -- Modified to select the base uom for the uom class defined on po.
4024: where mum.uom_class = (SELECT mum2.uom_class
4025: FROM mtl_units_of_measure mum2

Line 4025: FROM mtl_units_of_measure mum2

4021: , mtl_units_of_measure mum
4022: -- Bug 2619063, 2614016
4023: -- Modified to select the base uom for the uom class defined on po.
4024: where mum.uom_class = (SELECT mum2.uom_class
4025: FROM mtl_units_of_measure mum2
4026: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
4027: and mum.base_uom_flag = 'Y'
4028: and pol.ITEM_ID is null
4029: and pol.item_description is not null

Line 4491: , mtl_units_of_measure mum

4487: 0,
4488: 0,
4489: 'N'
4490: from po_lines_all pol
4491: , mtl_units_of_measure mum
4492: -- Bug 2619063, 2614016
4493: -- Modified to select the base uom for the uom class defined on po.
4494: where mum.uom_class = (SELECT mum2.uom_class
4495: FROM mtl_units_of_measure mum2

Line 4495: FROM mtl_units_of_measure mum2

4491: , mtl_units_of_measure mum
4492: -- Bug 2619063, 2614016
4493: -- Modified to select the base uom for the uom class defined on po.
4494: where mum.uom_class = (SELECT mum2.uom_class
4495: FROM mtl_units_of_measure mum2
4496: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
4497: and mum.base_uom_flag = 'Y'
4498: and pol.ITEM_ID is null
4499: and pol.item_description is not null

Line 4938: , mtl_units_of_measure mum

4934: 0,
4935: 0,
4936: 'N'
4937: from po_lines_all pol
4938: , mtl_units_of_measure mum
4939: -- Bug 2619063, 2614016
4940: -- Modified to select the base uom for the uom class defined on po.
4941: where mum.uom_class = (SELECT mum2.uom_class
4942: FROM mtl_units_of_measure mum2

Line 4942: FROM mtl_units_of_measure mum2

4938: , mtl_units_of_measure mum
4939: -- Bug 2619063, 2614016
4940: -- Modified to select the base uom for the uom class defined on po.
4941: where mum.uom_class = (SELECT mum2.uom_class
4942: FROM mtl_units_of_measure mum2
4943: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
4944: and mum.base_uom_flag = 'Y'
4945: and pol.ITEM_ID is null
4946: and pol.item_description is not null

Line 5360: , mtl_units_of_measure mum

5356: 0,
5357: 0,
5358: 'N'
5359: from po_lines_all pol
5360: , mtl_units_of_measure mum
5361: -- Bug 2619063, 2614016
5362: -- Modified to select the base uom for the uom class defined on po.
5363: where mum.uom_class = (SELECT mum2.uom_class
5364: FROM mtl_units_of_measure mum2

Line 5364: FROM mtl_units_of_measure mum2

5360: , mtl_units_of_measure mum
5361: -- Bug 2619063, 2614016
5362: -- Modified to select the base uom for the uom class defined on po.
5363: where mum.uom_class = (SELECT mum2.uom_class
5364: FROM mtl_units_of_measure mum2
5365: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
5366: and mum.base_uom_flag = 'Y'
5367: and pol.ITEM_ID is null
5368: and pol.item_description is not null

Line 5778: , mtl_units_of_measure mum

5774: 0,
5775: 0,
5776: 'N'
5777: from po_lines_all pol
5778: , mtl_units_of_measure mum
5779: -- Bug 2619063, 2614016
5780: -- Modified to select the base uom for the uom class defined on po.
5781: where mum.uom_class = (SELECT mum2.uom_class
5782: FROM mtl_units_of_measure mum2

Line 5782: FROM mtl_units_of_measure mum2

5778: , mtl_units_of_measure mum
5779: -- Bug 2619063, 2614016
5780: -- Modified to select the base uom for the uom class defined on po.
5781: where mum.uom_class = (SELECT mum2.uom_class
5782: FROM mtl_units_of_measure mum2
5783: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
5784: and mum.base_uom_flag = 'Y'
5785: and pol.ITEM_ID is null
5786: and pol.item_description is not null

Line 6129: , mtl_units_of_measure mum

6125: 0,
6126: 0,
6127: 'N'
6128: from po_lines_all pol
6129: , mtl_units_of_measure mum
6130: , rcv_shipment_lines rsl
6131: -- Bug 2619063, 2614016
6132: -- Modified to select the base uom for the uom class defined on po.
6133: where mum.uom_class = (SELECT mum2.uom_class

Line 6134: FROM mtl_units_of_measure mum2

6130: , rcv_shipment_lines rsl
6131: -- Bug 2619063, 2614016
6132: -- Modified to select the base uom for the uom class defined on po.
6133: where mum.uom_class = (SELECT mum2.uom_class
6134: FROM mtl_units_of_measure mum2
6135: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
6136: and mum.base_uom_flag = 'Y'
6137: and pol.ITEM_ID is null
6138: and pol.item_description is not null

Line 7139: mtl_units_of_measure mum

7135: 0,
7136: 'N'
7137: FROM
7138: po_lines_all pol,
7139: mtl_units_of_measure mum
7140: -- Bug 2619063, 2614016
7141: -- Modified to select the base uom for the uom class defined on po.
7142: WHERE mum.uom_class = (SELECT mum2.uom_class
7143: FROM mtl_units_of_measure mum2

Line 7143: FROM mtl_units_of_measure mum2

7139: mtl_units_of_measure mum
7140: -- Bug 2619063, 2614016
7141: -- Modified to select the base uom for the uom class defined on po.
7142: WHERE mum.uom_class = (SELECT mum2.uom_class
7143: FROM mtl_units_of_measure mum2
7144: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
7145: AND mum.base_uom_flag = 'Y'
7146: AND pol.ITEM_ID is NULL
7147: AND pol.item_description IS NOT NULL