[Home] [Help]
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
87: where inc.primary_key = rln.requisition_line_id
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,
213: financials_system_params_all pfsp,
214: financials_system_params_all rfsp,
215: gl_sets_of_books pgl,
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
346: and nvl(rhr.contractor_status,'NOT_APPLICABLE') <> 'PENDING'
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
382: and nvl(rhr.contractor_status,'NOT_APPLICABLE') <> 'PENDING'
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
418: and nvl(rhr.contractor_status,'NOT_APPLICABLE') <> 'PENDING'
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
454: and nvl(rhr.contractor_status,'NOT_APPLICABLE') <> 'PENDING'
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
491: and nvl(rhr.contractor_status,'NOT_APPLICABLE') <> 'PENDING'
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
529: and nvl(rhr.contractor_status,'NOT_APPLICABLE') <> 'PENDING'
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
988: inc.primary_key = rln.requisition_line_id
989: and (inc.line_location_id is null or inc.line_location_id = pll.line_location_id)
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
1443: inc.primary_key = rln.requisition_line_id
1444: and (inc.line_location_id is null or inc.line_location_id = pll.line_location_id)