[Home] [Help]
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
195: and pod.po_line_id = pol.po_line_id
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
222: where pod.line_location_id = pll.line_location_id
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
274: and pod.po_line_id = pol.po_line_id
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
294: and pod.po_header_id = poh.po_header_id
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
313: and pod.po_header_id = poh.po_header_id
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
332: and pod.po_header_id = poh.po_header_id
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
354: and pod.po_line_id = pol.po_line_id
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
374: and pod.po_header_id = poh.po_header_id
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
393: and pod.po_header_id = poh.po_header_id
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
412: and pod.po_header_id = poh.po_header_id
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
431: where pod.line_location_id = pll.line_location_id
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,
819: pon_auction_item_prices_all ponip,
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,
899: pon_auction_headers_all ponh,
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,
1065: pon_auction_item_prices_all ponip,
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,
1145: pon_auction_headers_all ponh,
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)
1265: use_hash(plc) use_hash(v1) use_hash(ga) use_hash(pgoa)
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
1278: hro.org_information_context='Accounting Information') hro,
1279: ( SELECT /*+ PARALLEL(pl) PARALLEL(ph) no_merge use_hash(ph, pl) */
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')
1294: and ph.po_header_id = pl.po_header_id
1372: l.po_line_id, l.item_id b_item_id, l.unit_meas_lookup_code b_unit_meas_lookup_code, l.cancel_flag, l.expiration_date, l.price_break_lookup_code, l.unit_price, l.min_release_amount bl_min_release_amount,
1373: l.creation_date bl_creation_date,
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
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,
1934: poa_dbi_pod_lowest_price_temp low,
1934: poa_dbi_pod_lowest_price_temp low,
1935: poa_dbi_pod_match_temp match,
1936: mtl_system_items item,
1937: po_releases_all por,
1938: po_headers_all ref,
1939: po_requisition_headers_all prh,
1940: mtl_parameters par,
1941: fii_gl_ccid_dimensions ccid,
1942: pon_auction_headers_all ponh
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,
2167: po_releases_all por,
2164: po_requisition_lines_all prl,
2165: po_req_distributions_all prd,
2166: financials_system_params_all fsp,
2167: po_releases_all por,
2168: po_headers_all ref,
2169: po_requisition_headers_all prh,
2170: mtl_parameters par,
2171: fii_gl_ccid_dimensions ccid,
2172: po_doc_style_headers doc_style,
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
2184: hro.org_information_context='Accounting Information') hro,
2185: po_doc_style_headers style,
2182: (select /*+ no_merge */ to_number(hro.org_information3) ship_to_ou_id,organization_id
2183: from hr_organization_information hro where
2184: hro.org_information_context='Accounting Information') hro,
2185: po_doc_style_headers style,
2186: po_headers_all phc,
2187: ( SELECT
2188: pl.item_id,
2189: ph.start_date,
2190: ph.end_date,
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')
2202: and ph.po_header_id = pl.po_header_id