APPS.POA_DBI_REQ_F_C dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 82: po_req_distributions_all rdn,

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,
86: hr_all_organization_units_tl hr

Line 207: po_req_distributions_all rdn,

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

Line 341: po_req_distributions_all rdn,

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'
345: and rln.requisition_header_id = rhr.requisition_header_id

Line 377: po_req_distributions_all rdn,

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'
381: and rln.requisition_header_id = rhr.requisition_header_id

Line 413: po_req_distributions_all rdn,

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'
417: and rln.requisition_header_id = rhr.requisition_header_id

Line 449: po_req_distributions_all rdn,

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'
453: and rln.requisition_header_id = rhr.requisition_header_id

Line 486: po_req_distributions_all rdn,

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'
490: and rln.requisition_header_id = rhr.requisition_header_id

Line 524: po_req_distributions_all rdn,

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'
528: and rln.requisition_header_id = rhr.requisition_header_id

Line 971: po_req_distributions_all rdn,

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

Line 1426: po_req_distributions_all rdn,

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