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_MO_LOVS dependencies on MTL_TRANSACTION_TYPES

Line 93: FROM mtl_txn_request_headers h, mtl_txn_request_lines l, mtl_transaction_types t

89: , h.header_id
90: , MAX(h.move_order_type)
91: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
92: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
93: FROM mtl_txn_request_headers h, mtl_txn_request_lines l, mtl_transaction_types t
94: WHERE l.header_id = h.header_id
95: AND l.transaction_type_id = t.transaction_type_id
96: AND h.organization_id = p_organization_id
97: AND h.header_status IN(3, 7, 8)

Line 112: FROM mtl_txn_request_headers h, mtl_txn_request_lines l, mtl_transaction_types t

108: , h.header_id
109: , MAX(h.move_order_type)
110: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
111: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
112: FROM mtl_txn_request_headers h, mtl_txn_request_lines l, mtl_transaction_types t
113: WHERE l.header_id = h.header_id
114: AND l.transaction_type_id = t.transaction_type_id
115: AND h.organization_id = p_organization_id
116: AND h.header_status IN(3, 7, 8)