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 489: , mtl_units_of_measure mum

485: pl.Item_Id)
486: uom_code
487: FROM rcv_supply rsup
488: -- bug 2805640
489: , mtl_units_of_measure mum
490: , po_lines_trx_v pl -- CLM project, bug 9403291
491: , mtl_system_items_vl msi
492: WHERE rsup.po_line_id = pl.po_line_id
493: -- bug 2805640

Line 1363: from mtl_units_of_measure muom

1359: Begin
1360:
1361: select uom_class
1362: into p_primary_uom_class
1363: from mtl_units_of_measure muom
1364: where muom.uom_code = p_primary_uom_code;
1365:
1366: Exception
1367: When others then p_primary_uom_class := '';

Line 1382: mtl_units_of_measure muom

1378: , ''
1379: , muc.uom_class uom_class
1380: from
1381: mtl_uom_conversions_val_v muc ,
1382: mtl_units_of_measure muom
1383: where muc.uom_class = p_primary_uom_class
1384: and muc.item_id = 0
1385: and nvl(muc.disable_date,sysdate+1)>sysdate
1386: and muc.unit_of_measure = muom.unit_of_measure

Line 1391: --FROM mtl_units_of_measure

1387: and nvl(muom.disable_date,sysdate+1) > sysdate
1388: and muom.uom_code like (l_code)
1389: order by muc.unit_of_measure;
1390:
1391: --FROM mtl_units_of_measure
1392: --WHERE base_uom_flag = 'Y'
1393: --AND uom_code LIKE (p_uom_code || '%')
1394: --ORDER BY Upper(uom_code);
1395:

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

1489: The following changes have been done while selecting Purchase Orders.
1490: i.e. doc type of PO.
1491: a. In the condition, "AND NVL(poll.approved_flag,'N') = 'Y' " ,
1492: nvl() has been removed.
1493: b. Removed the tables mtl_system_items_kfv and mtl_units_of_measure which are
1494: joined with po_lines_all table through outer join.
1495: c. Added the hint " +index(POH PO_HEADERS_U2) " to use the index PO_HEADERS_U2.
1496: d. Removed the Distinct clause from the select statement.
1497: */

Line 2977: , mtl_units_of_measure mum

2973: p_organization_id,
2974: pl.Item_Id)
2975: uom_code
2976: from po_lines_trx_v pl -- CLM project, bug 9403291
2977: , mtl_units_of_measure mum
2978: , mtl_system_items_vl msi
2979: where pl.item_id = msi.inventory_item_id (+)
2980: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
2981: -- and msi.organization_id = p_organization_id -- Bug 6437363

Line 3023: , mtl_units_of_measure mum

3019: p_organization_id,
3020: pl.Item_Id)
3021: uom_code
3022: from po_lines_trx_v pl -- CLM project, bug 9403291
3023: , mtl_units_of_measure mum
3024: , mtl_system_items_vl msi
3025: , mtl_related_items mri
3026: where msi.organization_id = p_organization_id -- Bug 6437363
3027: and msi.inventory_item_id = p_inventory_item_id -- Bug 6311550

Line 3080: , mtl_units_of_measure mum

3076: p_organization_id,
3077: pl.Item_Id)
3078: uom_code
3079: FROM rcv_supply rsup
3080: , mtl_units_of_measure mum
3081: , po_lines_trx_v pl -- CLM project, bug 9403291
3082: , mtl_system_items_vl msi
3083: WHERE rsup.po_line_id = pl.po_line_id
3084: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE

Line 3711: , mtl_units_of_measure mum

3707: 'N',
3708: ' ',
3709: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3710: from po_lines_trx_v pol -- CLM project, bug 9403291
3711: , mtl_units_of_measure mum
3712: -- Bug 2619063, 2614016
3713: -- Modified to select the base uom for the uom class defined on po.
3714: where mum.uom_class = (SELECT mum2.uom_class
3715: FROM mtl_units_of_measure mum2

Line 3715: FROM mtl_units_of_measure mum2

3711: , mtl_units_of_measure mum
3712: -- Bug 2619063, 2614016
3713: -- Modified to select the base uom for the uom class defined on po.
3714: where mum.uom_class = (SELECT mum2.uom_class
3715: FROM mtl_units_of_measure mum2
3716: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
3717: and mum.base_uom_flag = 'Y'
3718: and pol.ITEM_ID is null
3719: and pol.item_description is not null

Line 3909: , mtl_units_of_measure mum

3905: 'N',
3906: ' ',
3907: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3908: from po_lines_trx_v pol -- CLM project, bug 9403291
3909: , mtl_units_of_measure mum
3910: -- Bug 2619063, 2614016
3911: -- Modified to select the base uom for the uom class defined on po.
3912: where mum.uom_class = (SELECT mum2.uom_class
3913: FROM mtl_units_of_measure mum2

Line 3913: FROM mtl_units_of_measure mum2

3909: , mtl_units_of_measure mum
3910: -- Bug 2619063, 2614016
3911: -- Modified to select the base uom for the uom class defined on po.
3912: where mum.uom_class = (SELECT mum2.uom_class
3913: FROM mtl_units_of_measure mum2
3914: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
3915: and mum.base_uom_flag = 'Y'
3916: and pol.ITEM_ID is null
3917: and pol.vendor_product_num is not null

Line 4290: , mtl_units_of_measure mum

4286: 'N',
4287: ' ',
4288: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4289: from po_lines_trx_v pol -- CLM project, bug 9403291
4290: , mtl_units_of_measure mum
4291: -- Bug 2619063, 2614016
4292: -- Modified to select the base uom for the uom class defined on po.
4293: where mum.uom_class = (SELECT mum2.uom_class
4294: FROM mtl_units_of_measure mum2

Line 4294: FROM mtl_units_of_measure mum2

4290: , mtl_units_of_measure mum
4291: -- Bug 2619063, 2614016
4292: -- Modified to select the base uom for the uom class defined on po.
4293: where mum.uom_class = (SELECT mum2.uom_class
4294: FROM mtl_units_of_measure mum2
4295: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
4296: and mum.base_uom_flag = 'Y'
4297: and pol.ITEM_ID is null
4298: and pol.item_description is not null

Line 4489: , mtl_units_of_measure mum

4485: 'N',
4486: ' ',
4487: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4488: from po_lines_trx_v pol -- CLM project, bug 9403291
4489: , mtl_units_of_measure mum
4490: -- Bug 2619063, 2614016
4491: -- Modified to select the base uom for the uom class defined on po.
4492: where mum.uom_class = (SELECT mum2.uom_class
4493: FROM mtl_units_of_measure mum2

Line 4493: FROM mtl_units_of_measure mum2

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

Line 4876: , mtl_units_of_measure mum

4872: 'N',
4873: ' ',
4874: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4875: from po_lines_trx_v pol -- CLM project, bug 9403291
4876: , mtl_units_of_measure mum
4877: -- Bug 2619063, 2614016
4878: -- Modified to select the base uom for the uom class defined on po.
4879: where mum.uom_class = (SELECT mum2.uom_class
4880: FROM mtl_units_of_measure mum2

Line 4880: FROM mtl_units_of_measure mum2

4876: , mtl_units_of_measure mum
4877: -- Bug 2619063, 2614016
4878: -- Modified to select the base uom for the uom class defined on po.
4879: where mum.uom_class = (SELECT mum2.uom_class
4880: FROM mtl_units_of_measure mum2
4881: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
4882: and mum.base_uom_flag = 'Y'
4883: and pol.ITEM_ID is null
4884: and pol.item_description is not null

Line 5072: , mtl_units_of_measure mum

5068: 'N',
5069: ' ',
5070: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5071: from po_lines_trx_v pol -- CLM project, bug 9403291
5072: , mtl_units_of_measure mum
5073: -- Bug 2619063, 2614016
5074: -- Modified to select the base uom for the uom class defined on po.
5075: where mum.uom_class = (SELECT mum2.uom_class
5076: FROM mtl_units_of_measure mum2

Line 5076: FROM mtl_units_of_measure mum2

5072: , mtl_units_of_measure mum
5073: -- Bug 2619063, 2614016
5074: -- Modified to select the base uom for the uom class defined on po.
5075: where mum.uom_class = (SELECT mum2.uom_class
5076: FROM mtl_units_of_measure mum2
5077: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
5078: and mum.base_uom_flag = 'Y'
5079: and pol.ITEM_ID is null
5080: and pol.vendor_product_num is not null

Line 5425: , mtl_units_of_measure mum

5421: 'N',
5422: ' ',
5423: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5424: from po_lines_trx_v pol -- CLM project, bug 9403291
5425: , mtl_units_of_measure mum
5426: -- Bug 2619063, 2614016
5427: -- Modified to select the base uom for the uom class defined on po.
5428: where mum.uom_class = (SELECT mum2.uom_class
5429: FROM mtl_units_of_measure mum2

Line 5429: FROM mtl_units_of_measure mum2

5425: , mtl_units_of_measure mum
5426: -- Bug 2619063, 2614016
5427: -- Modified to select the base uom for the uom class defined on po.
5428: where mum.uom_class = (SELECT mum2.uom_class
5429: FROM mtl_units_of_measure mum2
5430: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
5431: and mum.base_uom_flag = 'Y'
5432: and pol.ITEM_ID is null
5433: and pol.item_description is not null

Line 5608: , mtl_units_of_measure mum

5604: 'N',
5605: ' ',
5606: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5607: from po_lines_trx_v pol -- CLM project, bug 9403291
5608: , mtl_units_of_measure mum
5609: -- Bug 2619063, 2614016
5610: -- Modified to select the base uom for the uom class defined on po.
5611: where mum.uom_class = (SELECT mum2.uom_class
5612: FROM mtl_units_of_measure mum2

Line 5612: FROM mtl_units_of_measure mum2

5608: , mtl_units_of_measure mum
5609: -- Bug 2619063, 2614016
5610: -- Modified to select the base uom for the uom class defined on po.
5611: where mum.uom_class = (SELECT mum2.uom_class
5612: FROM mtl_units_of_measure mum2
5613: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
5614: and mum.base_uom_flag = 'Y'
5615: and pol.ITEM_ID is null
5616: and pol.vendor_product_num is not null

Line 5953: , mtl_units_of_measure mum

5949: 'N',
5950: ' ',
5951: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5952: from po_lines_trx_v pol -- CLM project, bug 9403291
5953: , mtl_units_of_measure mum
5954: -- Bug 2619063, 2614016
5955: -- Modified to select the base uom for the uom class defined on po.
5956: where mum.uom_class = (SELECT mum2.uom_class
5957: FROM mtl_units_of_measure mum2

Line 5957: FROM mtl_units_of_measure mum2

5953: , mtl_units_of_measure mum
5954: -- Bug 2619063, 2614016
5955: -- Modified to select the base uom for the uom class defined on po.
5956: where mum.uom_class = (SELECT mum2.uom_class
5957: FROM mtl_units_of_measure mum2
5958: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
5959: and mum.base_uom_flag = 'Y'
5960: and pol.ITEM_ID is null
5961: and pol.item_description is not null

Line 6133: , mtl_units_of_measure mum

6129: 'N',
6130: ' ',
6131: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6132: from po_lines_trx_v pol -- CLM project, bug 9403291
6133: , mtl_units_of_measure mum
6134: -- Bug 2619063, 2614016
6135: -- Modified to select the base uom for the uom class defined on po.
6136: where mum.uom_class = (SELECT mum2.uom_class
6137: FROM mtl_units_of_measure mum2

Line 6137: FROM mtl_units_of_measure mum2

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

Line 6475: , mtl_units_of_measure mum

6471: 'N',
6472: ' ',
6473: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6474: from po_lines_trx_v pol -- CLM project, bug 9403291
6475: , mtl_units_of_measure mum
6476: -- Bug 2619063, 2614016
6477: -- Modified to select the base uom for the uom class defined on po.
6478: where mum.uom_class = (SELECT mum2.uom_class
6479: FROM mtl_units_of_measure mum2

Line 6479: FROM mtl_units_of_measure mum2

6475: , mtl_units_of_measure mum
6476: -- Bug 2619063, 2614016
6477: -- Modified to select the base uom for the uom class defined on po.
6478: where mum.uom_class = (SELECT mum2.uom_class
6479: FROM mtl_units_of_measure mum2
6480: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
6481: and mum.base_uom_flag = 'Y'
6482: and pol.ITEM_ID is null
6483: and pol.item_description is not null

Line 6654: , mtl_units_of_measure mum

6650: 'N',
6651: ' ',
6652: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6653: from po_lines_trx_v pol -- CLM project, bug 9403291
6654: , mtl_units_of_measure mum
6655: -- Bug 2619063, 2614016
6656: -- Modified to select the base uom for the uom class defined on po.
6657: where mum.uom_class = (SELECT mum2.uom_class
6658: FROM mtl_units_of_measure mum2

Line 6658: FROM mtl_units_of_measure mum2

6654: , mtl_units_of_measure mum
6655: -- Bug 2619063, 2614016
6656: -- Modified to select the base uom for the uom class defined on po.
6657: where mum.uom_class = (SELECT mum2.uom_class
6658: FROM mtl_units_of_measure mum2
6659: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
6660: and mum.base_uom_flag = 'Y'
6661: and pol.ITEM_ID is null
6662: and pol.vendor_product_num is not null

Line 6931: , mtl_units_of_measure mum

6927: rsh.shipment_num),
6928: DECODE (p_reqHeaderID,to_char(null),' ',
6929: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6930: from po_lines_trx_v pol -- CLM project, bug 9403291
6931: , mtl_units_of_measure mum
6932: ,rcv_shipment_lines rsl
6933: , rcv_shipment_headers rsh /* Added for Bug9257750 */
6934: -- Bug 2619063, 2614016
6935: -- Modified to select the base uom for the uom class defined on po.

Line 6937: FROM mtl_units_of_measure mum2

6933: , rcv_shipment_headers rsh /* Added for Bug9257750 */
6934: -- Bug 2619063, 2614016
6935: -- Modified to select the base uom for the uom class defined on po.
6936: where mum.uom_class = (SELECT mum2.uom_class
6937: FROM mtl_units_of_measure mum2
6938: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
6939: and mum.base_uom_flag = 'Y'
6940: and pol.ITEM_ID is null
6941: and pol.item_description is not null

Line 7269: , mtl_units_of_measure mum

7265: rsh.shipment_num),
7266: DECODE (p_reqHeaderID,to_char(null),' ',
7267: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7268: from po_lines_trx_v pol -- CLM project, bug 9403291
7269: , mtl_units_of_measure mum
7270: ,rcv_shipment_lines rsl
7271: , rcv_shipment_headers rsh /* Added for Bug9257750 */
7272: -- Bug 2619063, 2614016
7273: -- Modified to select the base uom for the uom class defined on po.

Line 7275: FROM mtl_units_of_measure mum2

7271: , rcv_shipment_headers rsh /* Added for Bug9257750 */
7272: -- Bug 2619063, 2614016
7273: -- Modified to select the base uom for the uom class defined on po.
7274: where mum.uom_class = (SELECT mum2.uom_class
7275: FROM mtl_units_of_measure mum2
7276: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
7277: and mum.base_uom_flag = 'Y'
7278: and pol.ITEM_ID is null
7279: and pol.item_description is not null

Line 8193: mtl_units_of_measure mum

8189: ' ',
8190: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
8191: FROM
8192: po_lines_trx_v pol, -- CLM project, bug 9403291
8193: mtl_units_of_measure mum
8194: -- Bug 2619063, 2614016
8195: -- Modified to select the base uom for the uom class defined on po.
8196: WHERE mum.uom_class = (SELECT mum2.uom_class
8197: FROM mtl_units_of_measure mum2

Line 8197: FROM mtl_units_of_measure mum2

8193: mtl_units_of_measure mum
8194: -- Bug 2619063, 2614016
8195: -- Modified to select the base uom for the uom class defined on po.
8196: WHERE mum.uom_class = (SELECT mum2.uom_class
8197: FROM mtl_units_of_measure mum2
8198: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
8199: AND mum.base_uom_flag = 'Y'
8200: AND pol.ITEM_ID is NULL
8201: AND pol.item_description IS NOT NULL