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_RCV_DIR_RCPT_APIS dependencies on MTL_UNITS_OF_MEASURE

Line 404: , mtl_units_of_measure mum

400: , po_line_locations poll
401: , po_lines pol
402: , po_releases por
403: , mtl_system_items msi
404: , mtl_units_of_measure mum
405: , po_distributions pod
406: WHERE pod.po_distribution_id = v_po_distribution_id
407: AND poh.po_header_id = poll.po_header_id
408: AND pol.po_line_id = poll.po_line_id

Line 1022: , mtl_units_of_measure mum

1018: , po_line_locations poll
1019: , po_lines pol
1020: , po_releases por
1021: , mtl_system_items msi
1022: , mtl_units_of_measure mum
1023: , po_distributions pod
1024: WHERE pod.po_distribution_id = v_po_distribution_id
1025: AND poh.po_header_id = poll.po_header_id
1026: AND pol.po_line_id = poll.po_line_id

Line 1768: , mtl_units_of_measure mum

1764: , po_requisition_headers porh
1765: , po_requisition_lines porl
1766: , mtl_system_items msi
1767: , mtl_system_items msi1
1768: , mtl_units_of_measure mum
1769: WHERE rsh.receipt_source_code <> 'VENDOR'
1770: AND rsl.requisition_line_id = porl.requisition_line_id(+)
1771: AND porl.requisition_header_id = porh.requisition_header_id(+)
1772: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 2609: , mtl_units_of_measure mum

2605: , NULL secondary_quantity --OPM Convergence
2606: FROM oe_order_lines_all oel
2607: , oe_order_headers_all oeh
2608: , mtl_system_items msi
2609: , mtl_units_of_measure mum
2610: WHERE oel.line_category_code = 'RETURN'
2611: AND oel.header_id = oeh.header_id
2612: AND oel.inventory_item_id = msi.inventory_item_id
2613: AND oel.ship_from_org_id = msi.organization_id

Line 3257: , mtl_units_of_measure mum

3253: , po_line_locations poll
3254: , po_lines pol
3255: , po_releases por
3256: , mtl_system_items msi
3257: , mtl_units_of_measure mum
3258: , po_distributions pod
3259: WHERE pod.po_distribution_id = v_po_distribution_id
3260: AND pod.line_location_id = poll.line_location_id
3261: AND NVL(poll.approved_flag, 'N') = 'Y'

Line 3421: , mtl_units_of_measure mum

3417: , po_requisition_headers porh
3418: , po_requisition_lines porl
3419: , mtl_system_items msi
3420: , mtl_system_items msi1
3421: , mtl_units_of_measure mum
3422: WHERE rsh.receipt_source_code <> 'VENDOR'
3423: AND rsl.requisition_line_id = porl.requisition_line_id(+)
3424: AND porl.requisition_header_id = porh.requisition_header_id(+)
3425: AND rsh.shipment_header_id = rsl.shipment_header_id