[Home] [Help]
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
534: where pod.po_distribution_id = inc.primary_key
535: and pod.po_line_id = pol.po_line_id
536: and pol.auction_header_id = ponbh.auction_header_id
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
554: where pod.po_distribution_id = inc.primary_key
555: and pod.po_line_id = pol.po_line_id
556: and pol.contract_id = ponbh.po_header_id
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
575: where pod.po_distribution_id = inc.primary_key
576: and pod.po_line_id = pol.po_line_id
577: and pol.from_header_id = ponbh.po_header_id
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
627: where pod.po_distribution_id = inc.primary_key
628: and pod.po_line_id = pol.po_line_id
629: and pol.auction_header_id = ponbh.auction_header_id
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
647: where pod.po_distribution_id = inc.primary_key
648: and pod.po_line_id = pol.po_line_id
649: and pol.contract_id = ponbh.po_header_id
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
668: where pod.po_distribution_id = inc.primary_key
669: and pod.po_line_id = pol.po_line_id
670: and pol.from_header_id = ponbh.po_header_id
741: pon_bid_headers ponbh,
742: pon_auction_item_prices_all ponip,
743: pon_auction_headers_all ponh,
744: poa_dbi_neg_po_rates neg_rates,
745: financials_system_params_all pfsp,
746: gl_sets_of_books pgl,
747: mtl_system_items pitem,
748: mtl_units_of_measure uom,
749: mtl_parameters ppar,
818: pon_bid_headers ponbh,
819: pon_auction_item_prices_all ponip,
820: pon_auction_headers_all ponh,
821: poa_dbi_neg_po_rates neg_rates,
822: financials_system_params_all pfsp,
823: gl_sets_of_books pgl,
824: mtl_system_items pitem,
825: mtl_units_of_measure uom,
826: mtl_parameters ppar,
897: pon_bid_headers ponbh,
898: pon_auction_item_prices_all ponip,
899: pon_auction_headers_all ponh,
900: poa_dbi_neg_po_rates neg_rates,
901: financials_system_params_all pfsp,
902: gl_sets_of_books pgl,
903: mtl_system_items pitem,
904: mtl_units_of_measure uom,
905: mtl_parameters ppar,
987: pon_bid_headers ponbh,
988: pon_auction_item_prices_all ponip,
989: pon_auction_headers_all ponh,
990: poa_dbi_neg_po_rates neg_rates,
991: financials_system_params_all pfsp,
992: gl_sets_of_books pgl,
993: mtl_system_items pitem,
994: mtl_units_of_measure uom,
995: mtl_parameters ppar,
1064: pon_bid_headers ponbh,
1065: pon_auction_item_prices_all ponip,
1066: pon_auction_headers_all ponh,
1067: poa_dbi_neg_po_rates neg_rates,
1068: financials_system_params_all pfsp,
1069: gl_sets_of_books pgl,
1070: mtl_system_items pitem,
1071: mtl_units_of_measure uom,
1072: mtl_parameters ppar,
1143: pon_bid_headers ponbh,
1144: pon_auction_item_prices_all ponip,
1145: pon_auction_headers_all ponh,
1146: poa_dbi_neg_po_rates neg_rates,
1147: financials_system_params_all pfsp,
1148: gl_sets_of_books pgl,
1149: mtl_system_items pitem,
1150: mtl_units_of_measure uom,
1151: mtl_parameters ppar,
1317: ( pgoa.purchasing_org_id in
1318: ( select /*+ ordered no_merge parallel(tfh) parallel(fsp1) parallel(fsp2) use_hash(tfh) use_hash(fsp1) use_hash(fsp2) */ tfh.start_org_id
1319: from
1320: mtl_procuring_txn_flow_hdrs_v tfh,
1321: financials_system_params_all fsp1,
1322: financials_system_params_all fsp2
1323: where pod.creation_date between nvl(tfh.start_date, pod.creation_date) and nvl(tfh.end_date, pod.creation_date)
1324: and fsp1.org_id = tfh.start_org_id
1325: and fsp1.purch_encumbrance_flag = 'N'
1318: ( select /*+ ordered no_merge parallel(tfh) parallel(fsp1) parallel(fsp2) use_hash(tfh) use_hash(fsp1) use_hash(fsp2) */ tfh.start_org_id
1319: from
1320: mtl_procuring_txn_flow_hdrs_v tfh,
1321: financials_system_params_all fsp1,
1322: financials_system_params_all fsp2
1323: where pod.creation_date between nvl(tfh.start_date, pod.creation_date) and nvl(tfh.end_date, pod.creation_date)
1324: and fsp1.org_id = tfh.start_org_id
1325: and fsp1.purch_encumbrance_flag = 'N'
1326: and fsp2.org_id = tfh.end_org_id
1383: ) l,
1384: (select /*+ PARALLEL(pgoa) no_merge */ distinct po_header_id, purchasing_org_id
1385: from po_ga_org_assignments pgoa
1386: where enabled_flag = 'Y') pgoa,
1387: financials_system_params_all fsp, -- to get the functional currency of the blanket agreement
1388: gl_sets_of_books poa_gl
1389: where l.po_header_id = b.po_header_id
1390: and l.item_id = ptmp.item_id
1391: and l.unit_meas_lookup_code = ptmp.unit_meas_lookup_code
1399: and fsp.set_of_books_id = poa_gl.set_of_books_id
1400: and ((pgoa.purchasing_org_id in
1401: (select /*+ ordered PARALLEL(tfh) PARALLEL(fsp1) PARALLEL(fsp2) no_merge use_hash(tfh) use_hash(fsp1) use_hash(fsp2) */ tfh.start_org_id
1402: from mtl_procuring_txn_flow_hdrs_v tfh,
1403: financials_system_params_all fsp1,
1404: financials_system_params_all fsp2
1405: where ptmp.creation_date between nvl(tfh.start_date, ptmp.creation_date) and nvl(tfh.end_date, ptmp.creation_date)
1406: and fsp1.org_id = tfh.start_org_id
1407: and fsp1.purch_encumbrance_flag = 'N'
1400: and ((pgoa.purchasing_org_id in
1401: (select /*+ ordered PARALLEL(tfh) PARALLEL(fsp1) PARALLEL(fsp2) no_merge use_hash(tfh) use_hash(fsp1) use_hash(fsp2) */ tfh.start_org_id
1402: from mtl_procuring_txn_flow_hdrs_v tfh,
1403: financials_system_params_all fsp1,
1404: financials_system_params_all fsp2
1405: where ptmp.creation_date between nvl(tfh.start_date, ptmp.creation_date) and nvl(tfh.end_date, ptmp.creation_date)
1406: and fsp1.org_id = tfh.start_org_id
1407: and fsp1.purch_encumbrance_flag = 'N'
1408: and fsp2.org_id = tfh.end_org_id
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,
1935: poa_dbi_pod_match_temp match,
1936: mtl_system_items item,
1937: po_releases_all por,
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,
2168: po_headers_all ref,
2169: po_requisition_headers_all prh,
2170: mtl_parameters par,
2227: ( pgoa.purchasing_org_id in
2228: ( select tfh.start_org_id
2229: from
2230: mtl_procuring_txn_flow_hdrs_v tfh,
2231: financials_system_params_all fsp1,
2232: financials_system_params_all fsp2
2233: where pod.creation_date between nvl(tfh.start_date, pod.creation_date) and nvl(tfh.end_date, pod.creation_date)
2234: and fsp1.org_id = tfh.start_org_id
2235: and fsp1.purch_encumbrance_flag = 'N'
2228: ( select tfh.start_org_id
2229: from
2230: mtl_procuring_txn_flow_hdrs_v tfh,
2231: financials_system_params_all fsp1,
2232: financials_system_params_all fsp2
2233: where pod.creation_date between nvl(tfh.start_date, pod.creation_date) and nvl(tfh.end_date, pod.creation_date)
2234: and fsp1.org_id = tfh.start_org_id
2235: and fsp1.purch_encumbrance_flag = 'N'
2236: and fsp2.org_id = tfh.end_org_id