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

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

Line 2524: , mtl_units_of_measure mum

2520: , NULL secondary_quantity --OPM Convergence
2521: FROM oe_order_lines_all oel
2522: , oe_order_headers_all oeh
2523: , mtl_system_items msi
2524: , mtl_units_of_measure mum
2525: WHERE oel.line_category_code = 'RETURN'
2526: AND oel.header_id = oeh.header_id
2527: AND oel.inventory_item_id = msi.inventory_item_id
2528: AND oel.ship_from_org_id = msi.organization_id

Line 3153: , mtl_units_of_measure mum

3149: , po_line_locations poll
3150: , po_lines pol
3151: , po_releases por
3152: , mtl_system_items msi
3153: , mtl_units_of_measure mum
3154: , po_distributions pod
3155: WHERE pod.po_distribution_id = v_po_distribution_id
3156: AND pod.line_location_id = poll.line_location_id
3157: AND NVL(poll.approved_flag, 'N') = 'Y'

Line 3317: , mtl_units_of_measure mum

3313: , po_requisition_headers porh
3314: , po_requisition_lines porl
3315: , mtl_system_items msi
3316: , mtl_system_items msi1
3317: , mtl_units_of_measure mum
3318: WHERE rsh.receipt_source_code <> 'VENDOR'
3319: AND rsl.requisition_line_id = porl.requisition_line_id(+)
3320: AND porl.requisition_header_id = porh.requisition_header_id(+)
3321: AND rsh.shipment_header_id = rsl.shipment_header_id