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.GML_MOBILE_RECEIPT dependencies on MTL_UNITS_OF_MEASURE

Line 131: , mtl_units_of_measure mum

127: , msi.concatenated_segments
128: , msi.outside_operation_flag
129: , mum.uom_code
130: from po_lines_all pl
131: , mtl_units_of_measure mum
132: , mtl_system_items_kfv msi
133: where pl.item_id = msi.inventory_item_id (+)
134: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
135: and Nvl(msi.organization_id, p_organization_id) = p_organization_id

Line 160: , mtl_units_of_measure mum

156: , msi.concatenated_segments
157: , msi.outside_operation_flag
158: , mum.uom_code
159: from po_lines_all pl
160: , mtl_units_of_measure mum
161: , mtl_system_items_kfv msi
162: , mtl_related_items mri
163: where Nvl(msi.organization_id, p_organization_id) = p_organization_id
164: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE

Line 198: , mtl_units_of_measure mum

194: , msi.concatenated_segments
195: , msi.outside_operation_flag
196: , mum.uom_code
197: FROM rcv_supply rsup
198: , mtl_units_of_measure mum
199: , po_lines_all pl
200: , mtl_system_items_kfv msi
201: WHERE rsup.po_line_id = pl.po_line_id
202: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE

Line 499: , mtl_units_of_measure mum

495: BEGIN
496: SELECT mum.uom_code
497: INTO x_uom_code
498: FROM po_lines pol
499: , mtl_units_of_measure mum
500: WHERE pol.po_header_id = p_po_header_id
501: AND pol.unit_meas_lookup_code IS NOT NULL
502: AND pol.item_id = p_item_id
503: AND mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE

Line 796: ,mtl_units_of_measure mum

792: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
793: AND poh.segment1 LIKE (p_doc_number)
794: AND exists ( select 'x'
795: from po_lines_all pol
796: ,mtl_units_of_measure mum
797: where mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE
798: and mum.base_uom_flag(+) = 'Y'
799: and pol.ITEM_ID is null
800: and pol.item_description like p_item_description||'%'

Line 1066: , mtl_units_of_measure mum

1062: 0,
1063: to_char(NULL),
1064: 'N'
1065: from po_lines_all pol
1066: , mtl_units_of_measure mum
1067: -- Bug 2619063, 2614016
1068: -- Modified to select the base uom for the uom class defined on po.
1069: where mum.uom_class = (SELECT mum2.uom_class
1070: FROM mtl_units_of_measure mum2

Line 1070: FROM mtl_units_of_measure mum2

1066: , mtl_units_of_measure mum
1067: -- Bug 2619063, 2614016
1068: -- Modified to select the base uom for the uom class defined on po.
1069: where mum.uom_class = (SELECT mum2.uom_class
1070: FROM mtl_units_of_measure mum2
1071: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
1072: and mum.base_uom_flag = 'Y'
1073: and pol.ITEM_ID is null
1074: and pol.item_description is not null

Line 1354: , mtl_units_of_measure mum

1350: 0,
1351: to_char(NULL),
1352: 'N'
1353: from po_lines_all pol
1354: , mtl_units_of_measure mum
1355: -- Bug 2619063, 2614016
1356: -- Modified to select the base uom for the uom class defined on po.
1357: where mum.uom_class = (SELECT mum2.uom_class
1358: FROM mtl_units_of_measure mum2

Line 1358: FROM mtl_units_of_measure mum2

1354: , mtl_units_of_measure mum
1355: -- Bug 2619063, 2614016
1356: -- Modified to select the base uom for the uom class defined on po.
1357: where mum.uom_class = (SELECT mum2.uom_class
1358: FROM mtl_units_of_measure mum2
1359: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
1360: and mum.base_uom_flag = 'Y'
1361: and pol.ITEM_ID is null
1362: and pol.item_description is not null

Line 1640: , mtl_units_of_measure mum

1636: 0,
1637: to_char(NULL),
1638: 'N'
1639: from po_lines_all pol
1640: , mtl_units_of_measure mum
1641: -- Bug 2619063, 2614016
1642: -- Modified to select the base uom for the uom class defined on po.
1643: where mum.uom_class = (SELECT mum2.uom_class
1644: FROM mtl_units_of_measure mum2

Line 1644: FROM mtl_units_of_measure mum2

1640: , mtl_units_of_measure mum
1641: -- Bug 2619063, 2614016
1642: -- Modified to select the base uom for the uom class defined on po.
1643: where mum.uom_class = (SELECT mum2.uom_class
1644: FROM mtl_units_of_measure mum2
1645: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
1646: and mum.base_uom_flag = 'Y'
1647: and pol.ITEM_ID is null
1648: and pol.item_description is not null

Line 1912: , mtl_units_of_measure mum

1908: 0,
1909: to_char(NULL),
1910: 'N'
1911: from po_lines_all pol
1912: , mtl_units_of_measure mum
1913: -- Bug 2619063, 2614016
1914: -- Modified to select the base uom for the uom class defined on po.
1915: where mum.uom_class = (SELECT mum2.uom_class
1916: FROM mtl_units_of_measure mum2

Line 1916: FROM mtl_units_of_measure mum2

1912: , mtl_units_of_measure mum
1913: -- Bug 2619063, 2614016
1914: -- Modified to select the base uom for the uom class defined on po.
1915: where mum.uom_class = (SELECT mum2.uom_class
1916: FROM mtl_units_of_measure mum2
1917: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
1918: and mum.base_uom_flag = 'Y'
1919: and pol.ITEM_ID is null
1920: and pol.item_description is not null

Line 2162: , mtl_units_of_measure mum

2158: 0,
2159: to_char(NULL),
2160: 'N'
2161: from po_lines_all pol
2162: , mtl_units_of_measure mum
2163: -- Bug 2619063, 2614016
2164: -- Modified to select the base uom for the uom class defined on po.
2165: where mum.uom_class = (SELECT mum2.uom_class
2166: FROM mtl_units_of_measure mum2

Line 2166: FROM mtl_units_of_measure mum2

2162: , mtl_units_of_measure mum
2163: -- Bug 2619063, 2614016
2164: -- Modified to select the base uom for the uom class defined on po.
2165: where mum.uom_class = (SELECT mum2.uom_class
2166: FROM mtl_units_of_measure mum2
2167: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
2168: and mum.base_uom_flag = 'Y'
2169: and pol.ITEM_ID is null
2170: and pol.item_description is not null

Line 2411: , mtl_units_of_measure mum

2407: 0,
2408: to_char(NULL),
2409: 'N'
2410: from po_lines_all pol
2411: , mtl_units_of_measure mum
2412: -- Bug 2619063, 2614016
2413: -- Modified to select the base uom for the uom class defined on po.
2414: where mum.uom_class = (SELECT mum2.uom_class
2415: FROM mtl_units_of_measure mum2

Line 2415: FROM mtl_units_of_measure mum2

2411: , mtl_units_of_measure mum
2412: -- Bug 2619063, 2614016
2413: -- Modified to select the base uom for the uom class defined on po.
2414: where mum.uom_class = (SELECT mum2.uom_class
2415: FROM mtl_units_of_measure mum2
2416: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
2417: and mum.base_uom_flag = 'Y'
2418: and pol.ITEM_ID is null
2419: and pol.item_description is not null

Line 2625: , mtl_units_of_measure mum

2621: 0,
2622: to_char(NULL),
2623: 'N'
2624: from po_lines_all pol
2625: , mtl_units_of_measure mum
2626: , rcv_shipment_lines rsl
2627: -- Bug 2619063, 2614016
2628: -- Modified to select the base uom for the uom class defined on po.
2629: where mum.uom_class = (SELECT mum2.uom_class

Line 2630: FROM mtl_units_of_measure mum2

2626: , rcv_shipment_lines rsl
2627: -- Bug 2619063, 2614016
2628: -- Modified to select the base uom for the uom class defined on po.
2629: where mum.uom_class = (SELECT mum2.uom_class
2630: FROM mtl_units_of_measure mum2
2631: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
2632: and mum.base_uom_flag = 'Y'
2633: and pol.ITEM_ID is null
2634: and pol.item_description is not null

Line 3091: ,mtl_units_of_measure mum

3087: 0,
3088: to_char(NULL),
3089: 'N'
3090: from po_lines_all pol
3091: ,mtl_units_of_measure mum
3092: -- Bug 2619063, 2614016
3093: -- Modified to select the base uom for the uom class defined on po.
3094: where mum.uom_class = (SELECT mum2.uom_class
3095: FROM mtl_units_of_measure mum2

Line 3095: FROM mtl_units_of_measure mum2

3091: ,mtl_units_of_measure mum
3092: -- Bug 2619063, 2614016
3093: -- Modified to select the base uom for the uom class defined on po.
3094: where mum.uom_class = (SELECT mum2.uom_class
3095: FROM mtl_units_of_measure mum2
3096: WHERE mum2.unit_of_measure(+) = pol.unit_meas_lookup_code)
3097: and mum.base_uom_flag = 'Y'
3098: and pol.ITEM_ID is null
3099: and pol.item_description is not null