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 63: , po_line_types plt

59: FROM rcv_supply ms
60: , rcv_transactions rt
61: , po_headers_all poh
62: , po_lines_all pol
63: , po_line_types plt
64: , mtl_parameters mp
65: WHERE poh.po_header_id = ms.po_header_id
66: AND ms.quantity > 0
67: AND ms.supply_type_code = 'RECEIVING'

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

91: OR rt.routing_header_id IS NULL)
92: ORDER BY decode(rtrim(poh.segment1,'0123456789'),null,null,poh.segment1),
93: decode(rtrim(poh.segment1,'0123456789'),null,to_number(poh.segment1),null); -- */
94:
95: /* Modified the above Query for Bug # 7113772. Removed the join from po_lines_all and po_line_types due to bad performance */
96:
97: SELECT DISTINCT poh.Segment1 ,
98: poh.po_Header_Id ,
99: poh.Type_LookUp_Code ,

Line 125: FROM po_Line_Types

121: AND (mp.wms_Enabled_Flag = 'N'
122: OR (mp.wms_Enabled_Flag = 'Y'
123: AND ( EXISTS
124: (SELECT 1
125: FROM po_Line_Types
126: WHERE Outside_Operation_Flag = 'Y'
127: AND Line_Type_Id IN
128: (SELECT Line_Type_Id
129: FROM po_Lines_trx_v

Line 276: po_line_types plt,--BUG 5166887

272: PO_LOOKUP_CODES PLC,
273: PO_LINES_trx_v pol, -- CLM project, bug 9403291
274: PO_LINE_LOCATIONS_trx_v PLL, -- CLM project, bug 9403291
275: PO_HEADERS_trx_v POH, -- CLM project, bug 9403291
276: po_line_types plt,--BUG 5166887
277: mtl_parameters mp --BUG 5166887
278: -- For Bug 7440217 Added RCV_PRAMETERS to find out if the organization is LCM enabled or not
279: , rcv_parameters rp
280: -- End for Bug 7440217

Line 976: , po_line_types plt

972: AND msik.mtl_transactions_enabled_flag = 'N')
973: OR exists
974: (select '1' from po_headers_all poh
975: , po_lines_all pol
976: , po_line_types plt
977: where rt.po_header_id is not null
978: and rt.po_header_id = poh.po_header_id
979: and poh.po_header_id = pol.po_header_id
980: and pol.line_type_id = plt.line_type_id

Line 1149: , po_line_types plt

1145: AND msik.mtl_transactions_enabled_flag = 'N')
1146: OR exists (select '1'
1147: from po_headers_all poh
1148: , po_lines_all pol
1149: , po_line_types plt
1150: where rt.po_header_id is not null
1151: and rt.po_header_id = poh.po_header_id
1152: and poh.po_header_id = pol.po_header_id
1153: and pol.line_type_id = plt.line_type_id