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 PO_REQUISITION_LINES_ALL

Line 81: po_requisition_lines_all rln,

77: rln.requisition_line_id
78: from
79: poa_dbi_req_inc inc,
80: po_requisition_headers_all rhr,
81: po_requisition_lines_all rln,
82: po_req_distributions_all rdn,
83: po_distributions_all pod,
84: po_headers_all poh,
85: po_doc_style_headers style,

Line 206: po_requisition_lines_all rln,

202: decode(pll.line_location_id, null, rgl.currency_code, pgl.currency_code) func_cur_code,
203: decode(pll.line_location_id, null, nvl(trunc(rln.rate_date),trunc(rln.creation_date)), nvl(trunc(poh.rate_date), trunc(pll.creation_date))) rate_date
204: FROM
205: po_requisition_headers_all rhr,
206: po_requisition_lines_all rln,
207: po_req_distributions_all rdn,
208: po_headers_all poh,
209: po_lines_all pol,
210: po_line_locations_all pll,

Line 334: po_requisition_lines_all rln,

330: decode(pll.line_location_id, null, rgl.currency_code, pgl.currency_code) func_cur_code,
331: decode(pll.line_location_id, null, nvl(trunc(rln.rate_date),trunc(rln.creation_date)), nvl(trunc(poh.rate_date), trunc(pll.creation_date))) rate_date
332: FROM
333: po_requisition_headers_all rhr,
334: po_requisition_lines_all rln,
335: po_headers_all poh,
336: po_line_locations_all pll,
337: financials_system_params_all pfsp,
338: financials_system_params_all rfsp,

Line 370: po_requisition_lines_all rln,

366: decode(pll.line_location_id, null, rgl.currency_code, pgl.currency_code) func_cur_code,
367: decode(pll.line_location_id, null, nvl(trunc(rln.rate_date),trunc(rln.creation_date)), nvl(trunc(poh.rate_date), trunc(pll.creation_date))) rate_date
368: FROM
369: po_requisition_headers_all rhr,
370: po_requisition_lines_all rln,
371: po_headers_all poh,
372: po_line_locations_all pll,
373: financials_system_params_all pfsp,
374: financials_system_params_all rfsp,

Line 406: po_requisition_lines_all rln,

402: decode(pll.line_location_id, null, rgl.currency_code, pgl.currency_code) func_cur_code,
403: decode(pll.line_location_id, null, nvl(trunc(rln.rate_date),trunc(rln.creation_date)), nvl(trunc(poh.rate_date), trunc(pll.creation_date))) rate_date
404: FROM
405: po_requisition_headers_all rhr,
406: po_requisition_lines_all rln,
407: po_headers_all poh,
408: po_line_locations_all pll,
409: financials_system_params_all pfsp,
410: financials_system_params_all rfsp,

Line 442: po_requisition_lines_all rln,

438: decode(pll.line_location_id, null, rgl.currency_code, pgl.currency_code) func_cur_code,
439: decode(pll.line_location_id, null, nvl(trunc(rln.rate_date),trunc(rln.creation_date)), nvl(trunc(poh.rate_date), trunc(pll.creation_date))) rate_date
440: FROM
441: po_requisition_headers_all rhr,
442: po_requisition_lines_all rln,
443: po_headers_all poh,
444: po_line_locations_all pll,
445: financials_system_params_all pfsp,
446: financials_system_params_all rfsp,

Line 478: po_requisition_lines_all rln,

474: decode(pll.line_location_id, null, rgl.currency_code, pgl.currency_code) func_cur_code,
475: decode(pll.line_location_id, null, nvl(trunc(rln.rate_date),trunc(rln.creation_date)), nvl(trunc(poh.rate_date), trunc(pll.creation_date))) rate_date
476: FROM
477: po_requisition_headers_all rhr,
478: po_requisition_lines_all rln,
479: po_headers_all poh,
480: po_lines_all pol,
481: po_line_locations_all pll,
482: financials_system_params_all pfsp,

Line 516: po_requisition_lines_all rln,

512: decode(pll.line_location_id, null, rgl.currency_code, pgl.currency_code) func_cur_code,
513: decode(pll.line_location_id, null, nvl(trunc(rln.rate_date),trunc(rln.creation_date)), nvl(trunc(poh.rate_date), trunc(pll.creation_date))) rate_date
514: FROM
515: po_requisition_headers_all rhr,
516: po_requisition_lines_all rln,
517: po_headers_all poh,
518: po_line_locations_all pll,
519: po_releases_all por,
520: financials_system_params_all pfsp,

Line 555: po_requisition_lines_all rln,

551: nvl(rln.currency_code,rgl.currency_code) txn_cur_code,
552: rgl.currency_code func_cur_code ,
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'

Line 578: po_requisition_lines_all rln,

574: nvl(rln.currency_code,rgl.currency_code) txn_cur_code,
575: rgl.currency_code func_cur_code,
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'

Line 970: po_requisition_lines_all rln,

966: ) base_uom_conv_rate
967: FROM
968: poa_dbi_req_inc inc,
969: poa_dbi_req_rates rat,
970: po_requisition_lines_all rln,
971: po_req_distributions_all rdn,
972: po_headers_all poh,
973: po_lines_all pol,
974: po_releases_all por,

Line 1425: po_requisition_lines_all rln,

1421: ) base_uom_conv_rate
1422: FROM
1423: poa_dbi_req_inc inc,
1424: poa_dbi_req_rates rat,
1425: po_requisition_lines_all rln,
1426: po_req_distributions_all rdn,
1427: po_headers_all poh,
1428: po_lines_all pol,
1429: po_releases_all por,