DBA Data[Home] [Help]

APPS.POA_DBI_REQ_F_C dependencies on PO_HEADERS_ALL

Line 84: po_headers_all poh,

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,
86: hr_all_organization_units_tl hr
87: where inc.primary_key = rln.requisition_line_id
88: and rln.requisition_line_id = rdn.requisition_line_id

Line 208: po_headers_all poh,

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,
211: po_distributions_all pod,
212: po_releases_all por,

Line 335: po_headers_all poh,

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,
339: gl_sets_of_books pgl,

Line 371: po_headers_all poh,

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,
375: gl_sets_of_books pgl,

Line 407: po_headers_all poh,

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,
411: gl_sets_of_books pgl,

Line 443: po_headers_all poh,

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,
447: gl_sets_of_books pgl,

Line 479: po_headers_all poh,

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,
483: financials_system_params_all rfsp,

Line 517: po_headers_all poh,

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,
521: financials_system_params_all rfsp,

Line 972: po_headers_all poh,

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,
975: financials_system_params_all pfsp,
976: mtl_parameters ppar,

Line 1427: po_headers_all poh,

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,
1430: financials_system_params_all pfsp,
1431: mtl_parameters ppar,