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.RCV_TABLE_FUNCTIONS dependencies on STANDARD

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

336: WHERE po_header_id IN(SELECT po_header_id
337: FROM po_headers
338: WHERE segment1 = p_po_num
339: -- Bug 13720644 Begin: type_lookup_code for Planned Purchase Order is 'PLANNED'
340: --AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
341: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
342: --Bug 13720644 End
343: AND org_id = NVL(p_org_id, org_id));
344:

Line 341: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')

337: FROM po_headers
338: WHERE segment1 = p_po_num
339: -- Bug 13720644 Begin: type_lookup_code for Planned Purchase Order is 'PLANNED'
340: --AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
341: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
342: --Bug 13720644 End
343: AND org_id = NVL(p_org_id, org_id));
344:
345: RETURN g_poh_row;

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

350: INTO g_poh_row
351: FROM po_headers_all
352: WHERE segment1 = p_po_num
353: -- Bug 13720644: type_lookup_code for Planned Purchase Order is 'PLANNED'
354: --AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
355: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
356: --Bug 13720644 End
357: AND org_id = NVL(p_org_id, org_id);
358:

Line 355: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')

351: FROM po_headers_all
352: WHERE segment1 = p_po_num
353: -- Bug 13720644: type_lookup_code for Planned Purchase Order is 'PLANNED'
354: --AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
355: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
356: --Bug 13720644 End
357: AND org_id = NVL(p_org_id, org_id);
358:
359: RETURN g_poh_row;

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

374: INTO g_poh_row
375: FROM po_headers_all
376: WHERE segment1 = p_po_num
377: -- Bug 13720644: type_lookup_code for Planned Purchase Order is 'PLANNED'
378: --AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
379: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
380: --Bug 13720644 End
381: AND org_id = g_default_org_id;
382:

Line 379: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')

375: FROM po_headers_all
376: WHERE segment1 = p_po_num
377: -- Bug 13720644: type_lookup_code for Planned Purchase Order is 'PLANNED'
378: --AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
379: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
380: --Bug 13720644 End
381: AND org_id = g_default_org_id;
382:
383: RETURN g_poh_row;