[Home] [Help]
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
86: , po_headers_all ga
87: , hr_organization_information hro
102: and to_number(hro.organization_id) = psc.ship_to_organization_id
103: and hro.org_information_context = 'Accounting Information'
104: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT'
105: and exists (SELECT 'blanket item'
106: FROM po_lines_all pl
107: , po_headers_all ph
108: WHERE ph.type_lookup_code = 'BLANKET'
109: and ph.po_header_id = pl.po_header_id
110: and nvl(pl.unit_meas_lookup_code,
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
329: , po_headers_all ga
330: WHERE inc.primary_key = pod.PO_DISTRIBUTION_ID
331: and phc.po_header_id = plc.po_header_id
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
510: , po_doc_style_headers style
511: , hr_organization_information hro
527: and to_number(hro.organization_id) = psc.ship_to_organization_id
528: and hro.org_information_context = 'Accounting Information'
529: and nvl(pod.distribution_type,'-99') <> 'AGREEMENT'
530: and not exists (SELECT 'blanket item'
531: FROM po_lines_all pl
532: , po_headers_all ph
533: WHERE ph.type_lookup_code = 'BLANKET'
534: and ph.po_header_id = pl.po_header_id
535: and nvl(pl.unit_meas_lookup_code,
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
830: and pod.line_location_id = psc.line_location_id
831: and psc.po_line_id = plc.po_line_id