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 PO_LINE_TYPES

Line 46: , po_line_types plt

42: FROM rcv_supply ms
43: , rcv_transactions rt
44: , po_headers_all poh
45: , po_lines_all pol
46: , po_line_types plt
47: , mtl_parameters mp
48: WHERE poh.po_header_id = ms.po_header_id
49: AND ms.quantity > 0
50: AND ms.supply_type_code = 'RECEIVING'

Line 78: /* Modified the above Query for Bug # 7113772. Removed the join from po_lines_all and po_line_types due to bad performance */

74: OR rt.routing_header_id IS NULL)
75: ORDER BY decode(rtrim(poh.segment1,'0123456789'),null,null,poh.segment1),
76: decode(rtrim(poh.segment1,'0123456789'),null,to_number(poh.segment1),null); -- */
77:
78: /* Modified the above Query for Bug # 7113772. Removed the join from po_lines_all and po_line_types due to bad performance */
79:
80: SELECT DISTINCT poh.Segment1 ,
81: poh.po_Header_Id ,
82: poh.Type_LookUp_Code ,

Line 107: FROM po_Line_Types

103: AND (mp.wms_Enabled_Flag = 'N'
104: OR (mp.wms_Enabled_Flag = 'Y'
105: AND ( EXISTS
106: (SELECT 1
107: FROM po_Line_Types
108: WHERE Outside_Operation_Flag = 'Y'
109: AND Line_Type_Id IN
110: (SELECT Line_Type_Id
111: FROM po_Lines_All

Line 255: po_line_types plt,--BUG 5166887

251: PO_LOOKUP_CODES PLC,
252: PO_LINES_ALL pol,
253: PO_LINE_LOCATIONS_ALL PLL,
254: PO_HEADERS_ALL POH,
255: po_line_types plt,--BUG 5166887
256: mtl_parameters mp --BUG 5166887
257: -- For Bug 7440217 Added RCV_PRAMETERS to find out if the organization is LCM enabled or not
258: , rcv_parameters rp
259: -- End for Bug 7440217

Line 946: , po_line_types plt

942: AND msik.mtl_transactions_enabled_flag = 'N')
943: OR exists
944: (select '1' from po_headers_all poh
945: , po_lines_all pol
946: , po_line_types plt
947: where rt.po_header_id is not null
948: and rt.po_header_id = poh.po_header_id
949: and poh.po_header_id = pol.po_header_id
950: and pol.line_type_id = plt.line_type_id

Line 1117: , po_line_types plt

1113: AND msik.mtl_transactions_enabled_flag = 'N')
1114: OR exists (select '1'
1115: from po_headers_all poh
1116: , po_lines_all pol
1117: , po_line_types plt
1118: where rt.po_header_id is not null
1119: and rt.po_header_id = poh.po_header_id
1120: and poh.po_header_id = pol.po_header_id
1121: and pol.line_type_id = plt.line_type_id