77: , to_number(hro.org_information3) org_information3
78: , nvl(pod.rate_date,pod.creation_date) rate_date
79: , phc.rate_type
80: FROM poa_edw_po_dist_inc inc,
81: po_distributions_all pod
82: , po_line_locations_all psc
83: , po_lines_all plc
84: , po_doc_style_headers style
85: , po_headers_all phc
320: , fnd_global.conc_program_id
321: , p_start_time
322: FROM poa_edw_po_dist_inc inc,
323: gl_sets_of_books gl
324: , po_distributions_all pod
325: , po_doc_style_headers style
326: , po_line_locations_all psc
327: , po_lines_all plc
328: , po_headers_all phc
501: , fnd_global.conc_program_id
502: , p_start_time
503: FROM poa_edw_po_dist_inc inc,
504: gl_sets_of_books gl
505: , po_distributions_all pod
506: , po_line_locations_all psc
507: , po_lines_all plc
508: , po_headers_all phc
509: , po_headers_all ga
821: v_rate,
822: v_approved_date,
823: v_Currency_Conv_Rate
824: FROM gl_sets_of_books gl
825: , po_distributions_all pod
826: , po_line_locations_all psc
827: , po_lines_all plc
828: , po_headers_all phc
829: WHERE pod.po_distribution_id = p_po_distribution_id