APPS.POA_DBI_REQ_F_C dependencies on PO_REQUISITION_HEADERS_ALL

Line 80: po_requisition_headers_all rhr,

76: pod.req_distribution_id,
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,

Line 205: po_requisition_headers_all rhr,

201: decode(pll.line_location_id, null, nvl(rln.currency_code, rgl.currency_code),poh.currency_code) txn_cur_code,
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,

Line 333: po_requisition_headers_all rhr,

329: decode(pll.line_location_id, null, nvl(rln.currency_code, rgl.currency_code),poh.currency_code) txn_cur_code,
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,

Line 369: po_requisition_headers_all rhr,

365: decode(pll.line_location_id, null, nvl(rln.currency_code, rgl.currency_code),poh.currency_code) txn_cur_code,
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,

Line 405: po_requisition_headers_all rhr,

401: decode(pll.line_location_id, null, nvl(rln.currency_code, rgl.currency_code),poh.currency_code) txn_cur_code,
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,

Line 441: po_requisition_headers_all rhr,

437: decode(pll.line_location_id, null, nvl(rln.currency_code, rgl.currency_code),poh.currency_code) txn_cur_code,
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,

Line 477: po_requisition_headers_all rhr,

473: decode(pll.line_location_id, null, nvl(rln.currency_code, rgl.currency_code),poh.currency_code) txn_cur_code,
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,

Line 515: po_requisition_headers_all rhr,

511: decode(pll.line_location_id, null, nvl(rln.currency_code, rgl.currency_code),poh.currency_code) txn_cur_code,
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,

Line 554: FROM po_requisition_headers_all rhr,

550: ceil(rownum/l_batch_size) batch_id,
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'

Line 577: FROM po_requisition_headers_all rhr,

573: ceil(rownum/l_batch_size) batch_id,
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'

Line 983: po_requisition_headers_all rhr,

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
987: WHERE

Line 1438: po_requisition_headers_all rhr,

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
1442: WHERE