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.

[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on STANDARD

Line 336: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')

332: FROM po_headers_all
333: WHERE po_header_id IN(SELECT po_header_id
334: FROM po_headers
335: WHERE segment1 = p_po_num
336: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
337: AND org_id = NVL(p_org_id, org_id));
338:
339: RETURN g_poh_row;
340: EXCEPTION

Line 347: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')

343: SELECT *
344: INTO g_poh_row
345: FROM po_headers_all
346: WHERE segment1 = p_po_num
347: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
348: AND org_id = NVL(p_org_id, org_id);
349:
350: RETURN g_poh_row;
351: EXCEPTION

Line 368: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')

364: SELECT *
365: INTO g_poh_row
366: FROM po_headers_all
367: WHERE segment1 = p_po_num
368: AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
369: AND org_id = g_default_org_id;
370:
371: RETURN g_poh_row;
372: EXCEPTION