[Home] [Help]
186: poh.currency_code txn_cur_code,
187: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
188: from
189: po_lines_all pol,
190: po_line_locations_all pll,
191: po_headers_all poh,
192: po_distributions_all pod,
193: gl_sets_of_books poa_gl
194: where pod.line_location_id = pll.line_location_id
213: poh.currency_code txn_cur_code,
214: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
215: from
216: po_lines_all pol,
217: po_line_locations_all pll,
218: po_headers_all poh,
219: po_releases_all por,
220: po_distributions_all pod,
221: gl_sets_of_books poa_gl
265: poh.currency_code txn_cur_code,
266: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
267: from
268: po_lines_all pol,
269: po_line_locations_all pll,
270: po_headers_all poh,
271: po_distributions_all pod,
272: gl_sets_of_books poa_gl
273: where pod.line_location_id = pll.line_location_id
285: poa_gl.currency_code func_cur_code,
286: poh.currency_code txn_cur_code,
287: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
288: from
289: po_line_locations_all pll,
290: po_headers_all poh,
291: po_distributions_all pod,
292: gl_sets_of_books poa_gl
293: where pod.line_location_id = pll.line_location_id
304: poa_gl.currency_code func_cur_code,
305: poh.currency_code txn_cur_code,
306: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
307: from
308: po_line_locations_all pll,
309: po_headers_all poh,
310: po_distributions_all pod,
311: gl_sets_of_books poa_gl
312: where pod.line_location_id = pll.line_location_id
323: poa_gl.currency_code func_cur_code,
324: poh.currency_code txn_cur_code,
325: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
326: from
327: po_line_locations_all pll,
328: po_headers_all poh,
329: po_distributions_all pod,
330: gl_sets_of_books poa_gl
331: where pod.line_location_id = pll.line_location_id
345: poh.currency_code txn_cur_code,
346: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
347: from
348: po_lines_all pol,
349: po_line_locations_all pll,
350: po_headers_all poh,
351: po_distributions_all pod,
352: gl_sets_of_books poa_gl
353: where pod.line_location_id = pll.line_location_id
365: poa_gl.currency_code func_cur_code,
366: poh.currency_code txn_cur_code,
367: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
368: from
369: po_line_locations_all pll,
370: po_headers_all poh,
371: po_distributions_all pod,
372: gl_sets_of_books poa_gl
373: where pod.line_location_id = pll.line_location_id
384: poa_gl.currency_code func_cur_code,
385: poh.currency_code txn_cur_code,
386: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
387: from
388: po_line_locations_all pll,
389: po_headers_all poh,
390: po_distributions_all pod,
391: gl_sets_of_books poa_gl
392: where pod.line_location_id = pll.line_location_id
403: poa_gl.currency_code func_cur_code,
404: poh.currency_code txn_cur_code,
405: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
406: from
407: po_line_locations_all pll,
408: po_headers_all poh,
409: po_distributions_all pod,
410: gl_sets_of_books poa_gl
411: where pod.line_location_id = pll.line_location_id
422: poa_gl.currency_code func_cur_code,
423: poh.currency_code txn_cur_code,
424: trunc(nvl(pod.rate_date, pod.creation_date)) rate_date
425: from
426: po_line_locations_all pll,
427: po_headers_all poh,
428: po_releases_all por,
429: po_distributions_all pod,
430: gl_sets_of_books poa_gl
734: ) neg_base_uom_conv_rate
735: from
736: poa_dbi_pod_inc inc,
737: po_distributions_all pod,
738: po_line_locations_all pll,
739: po_lines_all pol,
740: pon_bid_item_prices ponbip,
741: pon_bid_headers ponbh,
742: pon_auction_item_prices_all ponip,
809: ) neg_base_uom_conv_rate
810: from
811: poa_dbi_pod_inc inc,
812: po_distributions_all pod,
813: po_line_locations_all pll,
814: po_lines_all pol,
815: po_headers_all poh_orig,
816: po_lines_all pol_orig,
817: pon_bid_item_prices ponbip,
889: ) neg_base_uom_conv_rate
890: from
891: poa_dbi_pod_inc inc,
892: po_distributions_all pod,
893: po_line_locations_all pll,
894: po_lines_all pol,
895: po_headers_all poh_orig,
896: pon_bid_item_prices ponbip,
897: pon_bid_headers ponbh,
980: ) neg_base_uom_conv_rate
981: from
982: poa_dbi_pod_inc inc,
983: po_distributions_all pod,
984: po_line_locations_all pll,
985: po_lines_all pol,
986: pon_bid_item_prices ponbip,
987: pon_bid_headers ponbh,
988: pon_auction_item_prices_all ponip,
1055: ) neg_base_uom_conv_rate
1056: from
1057: poa_dbi_pod_inc inc,
1058: po_distributions_all pod,
1059: po_line_locations_all pll,
1060: po_lines_all pol,
1061: po_headers_all poh_orig,
1062: po_lines_all pol_orig,
1063: pon_bid_item_prices ponbip,
1135: ) neg_base_uom_conv_rate
1136: from
1137: poa_dbi_pod_inc inc,
1138: po_distributions_all pod,
1139: po_line_locations_all pll,
1140: po_lines_all pol,
1141: po_headers_all poh_orig,
1142: pon_bid_item_prices ponbip,
1143: pon_bid_headers ponbh,
1255: pll.ship_to_organization_id
1256: FROM
1257: poa_dbi_pod_inc inc,
1258: po_distributions_all pod,
1259: po_line_locations_all pll,
1260: po_lines_all pol,
1261: po_headers_all poh,
1262: po_doc_style_headers style,
1263: ( SELECT /*+ PARALLEL(pod) PARALLEL(psc) PARALLEL(plc) PARALLEL(inc)
1268: pod.po_distribution_id,
1269: hro.ship_to_ou_id
1270: FROM
1271: po_distributions_all pod,
1272: po_line_locations_all psc,
1273: po_lines_all plc,
1274: poa_dbi_pod_inc inc,
1275: po_headers_all ga,
1276: (select /*+ no_merge */ to_number(hro.org_information3) ship_to_ou_id,organization_id
1466: nvl(rd.quantity_ordered,0)-nvl(rd.quantity_cancelled,0) else 0 END) line_qty
1467: ,sum(case when rll.approved_flag='Y' and rd.creation_date < b.creation_date then
1468: nvl(rd.quantity_ordered,0)-nvl(rd.quantity_cancelled,0) else 0 end) line_all_qty
1469: from bb b
1470: ,po_line_locations_all rll
1471: ,po_distributions_all rd
1472: where b.std_id = rll.po_line_id(+)
1473: and rll.line_location_id = rd.line_location_id(+)
1474: and nvl(rd.distribution_type,'-99') <> 'AGREEMENT'
1482: b.po_distribution_id, b.po_header_id,
1483: sum(case when rd.creation_date < b.creation_date then
1484: nvl(rll.price_override,0) * (nvl(rd.quantity_ordered,0)-nvl(rd.quantity_cancelled,0)) else 0 END) blanket_amt
1485: from bb b
1486: ,po_line_locations_all rll
1487: ,po_distributions_all rd
1488: where b.std_id = rll.po_line_id(+)
1489: and rll.line_location_id = rd.line_location_id(+)
1490: and nvl(rd.distribution_type,'-99') <> 'AGREEMENT'
1491: and (rll.shipment_type is null or rll.shipment_type in ('BLANKET', 'STANDARD', 'PRICE BREAK'))
1492: GROUP by b.po_distribution_id, b.po_header_id
1493: ) bblanket,
1494: poa_dbi_pod_match_temp ptmp3,
1495: po_line_locations_all pb
1496: where blanket.po_distribution_id = ptmp3.po_distribution_id
1497: and blanket.po_distribution_id = bblanket.po_distribution_id
1498: and blanket.po_header_id = bblanket.po_header_id
1499: and blanket.b_item_id = ptmp3.item_id
1924: pod.rate,
1925: pod.amount_ordered,
1926: pod.amount_cancelled
1927: ) pod,
1928: po_line_locations_all pll,
1929: po_lines_all pol,
1930: po_headers_all poh,
1931: po_requisition_lines_all prl,
1932: po_req_distributions_all prd,
2157: poa_dbi_neg_details negd,
2158: poa_dbi_pod_rates rat,
2159: gl_sets_of_books poa_gl,
2160: po_distributions_all pod,
2161: po_line_locations_all pll,
2162: po_lines_all pol,
2163: po_headers_all poh,
2164: po_requisition_lines_all prl,
2165: po_req_distributions_all prd,
2174: ( SELECT /*+ cardinality(inc,1) */
2175: distinct pod.po_distribution_id, hro.ship_to_ou_id
2176: FROM
2177: po_distributions_all pod,
2178: po_line_locations_all psc,
2179: po_lines_all plc,
2180: poa_dbi_pod_inc inc,
2181: po_headers_all ga,
2182: (select /*+ no_merge */ to_number(hro.org_information3) ship_to_ou_id,organization_id