[Home] [Help]
185: poa_gl.currency_code func_cur_code,
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
212: poa_gl.currency_code func_cur_code,
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,
264: poa_gl.currency_code func_cur_code,
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
344: poa_gl.currency_code func_cur_code,
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
525: pgl.currency_code func_cur_code,
526: nvl(trunc(ponh.rate_date), trunc(ponh.creation_date)) rate_date
527: from poa_dbi_pod_inc inc,
528: po_distributions_all pod,
529: po_lines_all pol,
530: pon_bid_headers ponbh,
531: pon_auction_headers_all ponh,
532: financials_system_params_all pfsp,
533: gl_sets_of_books pgl
545: pgl.currency_code func_cur_code,
546: nvl(trunc(ponh.rate_date), trunc(ponh.creation_date)) rate_date
547: from poa_dbi_pod_inc inc,
548: po_distributions_all pod,
549: po_lines_all pol,
550: pon_bid_headers ponbh,
551: pon_auction_headers_all ponh,
552: financials_system_params_all pfsp,
553: gl_sets_of_books pgl
566: nvl(trunc(ponh.rate_date), trunc(ponh.creation_date)) rate_date
567: from
568: poa_dbi_pod_inc inc,
569: po_distributions_all pod,
570: po_lines_all pol,
571: pon_bid_headers ponbh,
572: pon_auction_headers_all ponh,
573: financials_system_params_all pfsp,
574: gl_sets_of_books pgl
618: pgl.currency_code func_cur_code,
619: nvl(trunc(ponh.rate_date), trunc(ponh.creation_date)) rate_date
620: from poa_dbi_pod_inc inc,
621: po_distributions_all pod,
622: po_lines_all pol,
623: pon_bid_headers ponbh,
624: pon_auction_headers_all ponh,
625: financials_system_params_all pfsp,
626: gl_sets_of_books pgl
638: pgl.currency_code func_cur_code,
639: nvl(trunc(ponh.rate_date), trunc(ponh.creation_date)) rate_date
640: from poa_dbi_pod_inc inc,
641: po_distributions_all pod,
642: po_lines_all pol,
643: pon_bid_headers ponbh,
644: pon_auction_headers_all ponh,
645: financials_system_params_all pfsp,
646: gl_sets_of_books pgl
659: nvl(trunc(ponh.rate_date), trunc(ponh.creation_date)) rate_date
660: from
661: poa_dbi_pod_inc inc,
662: po_distributions_all pod,
663: po_lines_all pol,
664: pon_bid_headers ponbh,
665: pon_auction_headers_all ponh,
666: financials_system_params_all pfsp,
667: gl_sets_of_books pgl
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,
743: pon_auction_headers_all ponh,
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,
818: pon_bid_headers ponbh,
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,
818: pon_bid_headers ponbh,
819: pon_auction_item_prices_all ponip,
820: pon_auction_headers_all ponh,
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,
898: pon_auction_item_prices_all ponip,
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,
989: pon_auction_headers_all ponh,
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,
1064: pon_bid_headers ponbh,
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,
1064: pon_bid_headers ponbh,
1065: pon_auction_item_prices_all ponip,
1066: pon_auction_headers_all ponh,
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,
1144: pon_auction_item_prices_all ponip,
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)
1264: PARALLEL(ga) no_merge use_hash(pod) use_hash(psc)
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
1277: from hr_organization_information hro where
1285: ph.global_agreement_flag,
1286: ph.po_header_id,
1287: pl.creation_date
1288: FROM
1289: po_lines_all pl,
1290: po_headers_all ph
1291: WHERE ph.type_lookup_code = 'BLANKET'
1292: and pl.price_break_lookup_code is not null
1293: AND ph.approved_flag IN ('Y', 'R')
1374: nvl(std.po_line_id, l.po_line_id) std_id,
1375: poa_gl.currency_code bl_func_cur_code, b.rate bl_rate
1376: from po_headers_all b,
1377: poa_dbi_pod_match_temp ptmp,
1378: po_lines_all std,
1379: (select /*+ PARALLEL(bl) no_merge */ bl.po_header_id, bl.item_id, bl.unit_meas_lookup_code,bl.expiration_date, bl.po_line_id, bl.min_release_amount, bl.unit_price, bl.cancel_flag, bl.price_break_lookup_code, bl.creation_date
1380: from po_lines_all bl
1381: where bl.price_break_lookup_code is not null
1382: and nvl(bl.cancel_flag, 'N') = 'N'
1376: from po_headers_all b,
1377: poa_dbi_pod_match_temp ptmp,
1378: po_lines_all std,
1379: (select /*+ PARALLEL(bl) no_merge */ bl.po_header_id, bl.item_id, bl.unit_meas_lookup_code,bl.expiration_date, bl.po_line_id, bl.min_release_amount, bl.unit_price, bl.cancel_flag, bl.price_break_lookup_code, bl.creation_date
1380: from po_lines_all bl
1381: where bl.price_break_lookup_code is not null
1382: and nvl(bl.cancel_flag, 'N') = 'N'
1383: ) l,
1384: (select /*+ PARALLEL(pgoa) no_merge */ distinct po_header_id, purchasing_org_id
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,
1933: financials_system_params_all fsp,
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,
2166: financials_system_params_all fsp,
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
2183: from hr_organization_information hro where
2193: ph.global_agreement_flag,
2194: ph.po_header_id,
2195: pl.creation_date
2196: FROM
2197: po_lines_all pl,
2198: po_headers_all ph
2199: WHERE ph.type_lookup_code = 'BLANKET'
2200: AND pl.price_break_lookup_code IS NOT null
2201: AND ph.approved_flag IN ('Y', 'R')