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.POA_DBI_REQ_F_C dependencies on GL_SETS_OF_BOOKS

Line 67: l_global_cur_code gl_sets_of_books.currency_code%type;

63: d_glob_date DATE;
64: l_rate_type VARCHAR2(30);
65: l_srate_type VARCHAR2(30);
66: l_sec_cur_yn NUMBER;
67: l_global_cur_code gl_sets_of_books.currency_code%type;
68: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
69: l_num_corrupt_rows number;
70: l_ret_variable boolean;
71: cursor corrupt_rows is

Line 68: l_sglobal_cur_code gl_sets_of_books.currency_code%type;

64: l_rate_type VARCHAR2(30);
65: l_srate_type VARCHAR2(30);
66: l_sec_cur_yn NUMBER;
67: l_global_cur_code gl_sets_of_books.currency_code%type;
68: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
69: l_num_corrupt_rows number;
70: l_ret_variable boolean;
71: cursor corrupt_rows is
72: select

Line 215: gl_sets_of_books pgl,

211: po_distributions_all pod,
212: po_releases_all por,
213: financials_system_params_all pfsp,
214: financials_system_params_all rfsp,
215: gl_sets_of_books pgl,
216: gl_sets_of_books rgl
217: WHERE
218: rhr.authorization_status = 'APPROVED'
219: and rln.source_type_code = 'VENDOR'

Line 216: gl_sets_of_books rgl

212: po_releases_all por,
213: financials_system_params_all pfsp,
214: financials_system_params_all rfsp,
215: gl_sets_of_books pgl,
216: gl_sets_of_books rgl
217: WHERE
218: rhr.authorization_status = 'APPROVED'
219: and rln.source_type_code = 'VENDOR'
220: and rln.requisition_header_id = rhr.requisition_header_id

Line 339: gl_sets_of_books pgl,

335: po_headers_all poh,
336: po_line_locations_all pll,
337: financials_system_params_all pfsp,
338: financials_system_params_all rfsp,
339: gl_sets_of_books pgl,
340: gl_sets_of_books rgl,
341: po_req_distributions_all rdn,
342: po_distributions_all pod
343: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')

Line 340: gl_sets_of_books rgl,

336: po_line_locations_all pll,
337: financials_system_params_all pfsp,
338: financials_system_params_all rfsp,
339: gl_sets_of_books pgl,
340: gl_sets_of_books rgl,
341: po_req_distributions_all rdn,
342: po_distributions_all pod
343: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')
344: and rln.source_type_code = 'VENDOR'

Line 375: gl_sets_of_books pgl,

371: po_headers_all poh,
372: po_line_locations_all pll,
373: financials_system_params_all pfsp,
374: financials_system_params_all rfsp,
375: gl_sets_of_books pgl,
376: gl_sets_of_books rgl,
377: po_req_distributions_all rdn,
378: po_distributions_all pod
379: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')

Line 376: gl_sets_of_books rgl,

372: po_line_locations_all pll,
373: financials_system_params_all pfsp,
374: financials_system_params_all rfsp,
375: gl_sets_of_books pgl,
376: gl_sets_of_books rgl,
377: po_req_distributions_all rdn,
378: po_distributions_all pod
379: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')
380: and rln.source_type_code = 'VENDOR'

Line 411: gl_sets_of_books pgl,

407: po_headers_all poh,
408: po_line_locations_all pll,
409: financials_system_params_all pfsp,
410: financials_system_params_all rfsp,
411: gl_sets_of_books pgl,
412: gl_sets_of_books rgl,
413: po_req_distributions_all rdn,
414: po_distributions_all pod
415: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')

Line 412: gl_sets_of_books rgl,

408: po_line_locations_all pll,
409: financials_system_params_all pfsp,
410: financials_system_params_all rfsp,
411: gl_sets_of_books pgl,
412: gl_sets_of_books rgl,
413: po_req_distributions_all rdn,
414: po_distributions_all pod
415: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')
416: and rln.source_type_code = 'VENDOR'

Line 447: gl_sets_of_books pgl,

443: po_headers_all poh,
444: po_line_locations_all pll,
445: financials_system_params_all pfsp,
446: financials_system_params_all rfsp,
447: gl_sets_of_books pgl,
448: gl_sets_of_books rgl,
449: po_req_distributions_all rdn,
450: po_distributions_all pod
451: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')

Line 448: gl_sets_of_books rgl,

444: po_line_locations_all pll,
445: financials_system_params_all pfsp,
446: financials_system_params_all rfsp,
447: gl_sets_of_books pgl,
448: gl_sets_of_books rgl,
449: po_req_distributions_all rdn,
450: po_distributions_all pod
451: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')
452: and rln.source_type_code = 'VENDOR'

Line 484: gl_sets_of_books pgl,

480: po_lines_all pol,
481: po_line_locations_all pll,
482: financials_system_params_all pfsp,
483: financials_system_params_all rfsp,
484: gl_sets_of_books pgl,
485: gl_sets_of_books rgl,
486: po_req_distributions_all rdn,
487: po_distributions_all pod
488: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')

Line 485: gl_sets_of_books rgl,

481: po_line_locations_all pll,
482: financials_system_params_all pfsp,
483: financials_system_params_all rfsp,
484: gl_sets_of_books pgl,
485: gl_sets_of_books rgl,
486: po_req_distributions_all rdn,
487: po_distributions_all pod
488: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')
489: and rln.source_type_code = 'VENDOR'

Line 522: gl_sets_of_books pgl,

518: po_line_locations_all pll,
519: po_releases_all por,
520: financials_system_params_all pfsp,
521: financials_system_params_all rfsp,
522: gl_sets_of_books pgl,
523: gl_sets_of_books rgl,
524: po_req_distributions_all rdn,
525: po_distributions_all pod
526: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')

Line 523: gl_sets_of_books rgl,

519: po_releases_all por,
520: financials_system_params_all pfsp,
521: financials_system_params_all rfsp,
522: gl_sets_of_books pgl,
523: gl_sets_of_books rgl,
524: po_req_distributions_all rdn,
525: po_distributions_all pod
526: WHERE rhr.authorization_status in ('APPROVED','CANCELLED','REJECTED','RETURNED')
527: and rln.source_type_code = 'VENDOR'

Line 557: gl_sets_of_books rgl

553: nvl(trunc(rln.rate_date),trunc(rln.creation_date)) rate_date
554: FROM po_requisition_headers_all rhr,
555: po_requisition_lines_all rln,
556: financials_system_params_all rfsp,
557: gl_sets_of_books rgl
558: WHERE rhr.authorization_status='INCOMPLETE'
559: and rln.source_type_code = 'VENDOR'
560: and rln.requisition_header_id = rhr.requisition_header_id
561: and rhr.approved_date is not null

Line 580: gl_sets_of_books rgl

576: nvl(trunc(rln.rate_date),trunc(rln.creation_date)) rate_date
577: FROM po_requisition_headers_all rhr,
578: po_requisition_lines_all rln,
579: financials_system_params_all rfsp,
580: gl_sets_of_books rgl
581: WHERE rhr.authorization_status='INCOMPLETE'
582: and rln.source_type_code = 'VENDOR'
583: and rln.requisition_header_id = rhr.requisition_header_id
584: and rhr.approved_date is not null

Line 981: gl_sets_of_books pgl,

977: mtl_system_items pitem,
978: financials_system_params_all rfsp,
979: mtl_parameters rpar,
980: mtl_system_items ritem,
981: gl_sets_of_books pgl,
982: gl_sets_of_books rgl,
983: po_requisition_headers_all rhr,
984: po_line_locations_all pll,
985: po_distributions_all pod,

Line 982: gl_sets_of_books rgl,

978: financials_system_params_all rfsp,
979: mtl_parameters rpar,
980: mtl_system_items ritem,
981: gl_sets_of_books pgl,
982: gl_sets_of_books rgl,
983: po_requisition_headers_all rhr,
984: po_line_locations_all pll,
985: po_distributions_all pod,
986: po_doc_style_headers style

Line 1436: gl_sets_of_books pgl,

1432: mtl_system_items pitem,
1433: financials_system_params_all rfsp,
1434: mtl_parameters rpar,
1435: mtl_system_items ritem,
1436: gl_sets_of_books pgl,
1437: gl_sets_of_books rgl,
1438: po_requisition_headers_all rhr,
1439: po_line_locations_all pll,
1440: po_distributions_all pod,

Line 1437: gl_sets_of_books rgl,

1433: financials_system_params_all rfsp,
1434: mtl_parameters rpar,
1435: mtl_system_items ritem,
1436: gl_sets_of_books pgl,
1437: gl_sets_of_books rgl,
1438: po_requisition_headers_all rhr,
1439: po_line_locations_all pll,
1440: po_distributions_all pod,
1441: po_doc_style_headers style