DBA Data[Home] [Help]

APPS.POA_DBI_PO_DIST_F_C dependencies on PON_AUCTION_HEADERS_ALL

Line 531: pon_auction_headers_all ponh,

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
534: where pod.po_distribution_id = inc.primary_key
535: and pod.po_line_id = pol.po_line_id

Line 551: pon_auction_headers_all ponh,

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
554: where pod.po_distribution_id = inc.primary_key
555: and pod.po_line_id = pol.po_line_id

Line 572: pon_auction_headers_all ponh,

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
575: where pod.po_distribution_id = inc.primary_key
576: and pod.po_line_id = pol.po_line_id

Line 624: pon_auction_headers_all ponh,

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
627: where pod.po_distribution_id = inc.primary_key
628: and pod.po_line_id = pol.po_line_id

Line 644: pon_auction_headers_all ponh,

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
647: where pod.po_distribution_id = inc.primary_key
648: and pod.po_line_id = pol.po_line_id

Line 665: pon_auction_headers_all ponh,

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
668: where pod.po_distribution_id = inc.primary_key
669: and pod.po_line_id = pol.po_line_id

Line 743: pon_auction_headers_all ponh,

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,
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,

Line 820: pon_auction_headers_all ponh,

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,
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,

Line 899: pon_auction_headers_all ponh,

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,
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,

Line 989: pon_auction_headers_all ponh,

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,
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,

Line 1066: pon_auction_headers_all ponh,

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,
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,

Line 1145: pon_auction_headers_all ponh,

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,
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,

Line 1942: pon_auction_headers_all ponh

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
1943: WHERE inc.primary_key = pod.PO_DISTRIBUTION_ID
1944: and inc.func_cur_code = rat.func_cur_code
1945: and inc.rate_date = rat.rate_date
1946: and inc.txn_cur_code = rat.txn_cur_code

Line 2173: pon_auction_headers_all ponh,

2169: po_requisition_headers_all prh,
2170: mtl_parameters par,
2171: fii_gl_ccid_dimensions ccid,
2172: po_doc_style_headers doc_style,
2173: pon_auction_headers_all ponh,
2174: ( SELECT /*+ cardinality(inc,1) */
2175: distinct pod.po_distribution_id, hro.ship_to_ou_id
2176: FROM
2177: po_distributions_all pod,