eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_DBI_PO_DIST_F_C dependencies on GL_SETS_OF_BOOKS

Line 89: l_global_cur_code gl_sets_of_books.currency_code%type;

85: d_end_date DATE;
86: d_glob_date DATE;
87: l_rate_type VARCHAR2(30);
88: l_srate_type varchar2(30);
89: l_global_cur_code gl_sets_of_books.currency_code%type;
90: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
91: BEGIN
92: Errbuf :=NULL;
93: Retcode:=0;

Line 90: l_sglobal_cur_code gl_sets_of_books.currency_code%type;

86: d_glob_date DATE;
87: l_rate_type VARCHAR2(30);
88: l_srate_type varchar2(30);
89: l_global_cur_code gl_sets_of_books.currency_code%type;
90: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
91: BEGIN
92: Errbuf :=NULL;
93: Retcode:=0;
94: l_global_cur_code := bis_common_parameters.get_currency_code;

Line 193: gl_sets_of_books poa_gl

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
196: and pod.po_header_id = poh.po_header_id
197: and pll.shipment_type in ('STANDARD','PREPAYMENT')

Line 221: gl_sets_of_books poa_gl

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
223: and pod.po_release_id = por.po_release_id
224: and pod.po_line_id = pol.po_line_id
225: and pod.po_header_id = poh.po_header_id

Line 272: gl_sets_of_books poa_gl

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
275: and pod.po_header_id = poh.po_header_id
276: and pll.shipment_type in ('STANDARD','PREPAYMENT')

Line 292: gl_sets_of_books poa_gl

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
295: and pll.shipment_type in ('STANDARD','PREPAYMENT')
296: and pll.approved_flag = 'Y'

Line 311: gl_sets_of_books poa_gl

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
314: and pll.shipment_type in ('STANDARD','PREPAYMENT')
315: and pll.approved_flag = 'Y'

Line 330: gl_sets_of_books poa_gl

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
333: and pll.shipment_type in ('STANDARD','PREPAYMENT')
334: and pll.approved_flag = 'Y'

Line 352: gl_sets_of_books poa_gl

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
355: and pod.po_header_id = poh.po_header_id
356: and pll.shipment_type in ('BLANKET', 'SCHEDULED')

Line 372: gl_sets_of_books poa_gl

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
375: and pll.shipment_type in ('BLANKET', 'SCHEDULED')
376: and pll.approved_flag = 'Y'

Line 391: gl_sets_of_books poa_gl

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
394: and pll.shipment_type in ('BLANKET', 'SCHEDULED')
395: and pll.approved_flag = 'Y'

Line 410: gl_sets_of_books poa_gl

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
413: and pll.shipment_type in ('BLANKET', 'SCHEDULED')
414: and pll.approved_flag = 'Y'

Line 430: gl_sets_of_books poa_gl

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
432: and pod.po_release_id = por.po_release_id
433: and pod.po_header_id = poh.po_header_id
434: and pll.shipment_type in ('BLANKET', 'SCHEDULED')

Line 533: gl_sets_of_books pgl

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
537: and ponbh.auction_header_id = ponh.auction_header_id

Line 553: gl_sets_of_books pgl

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
557: and ponbh.auction_header_id = ponh.auction_header_id

Line 574: gl_sets_of_books pgl

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
578: and ponbh.auction_header_id = ponh.auction_header_id

Line 626: gl_sets_of_books pgl

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
630: and ponbh.auction_header_id = ponh.auction_header_id

Line 646: gl_sets_of_books pgl

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
650: and ponbh.auction_header_id = ponh.auction_header_id

Line 667: gl_sets_of_books pgl

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
671: and ponbh.auction_header_id = ponh.auction_header_id

Line 746: gl_sets_of_books pgl,

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,
750: hz_parties hz

Line 823: gl_sets_of_books pgl,

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,
827: hz_parties hz

Line 902: gl_sets_of_books pgl,

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,
906: hz_parties hz

Line 992: gl_sets_of_books pgl,

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,
996: hz_parties hz

Line 1069: gl_sets_of_books pgl,

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,
1073: hz_parties hz

Line 1148: gl_sets_of_books pgl,

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,
1152: hz_parties hz

Line 1388: gl_sets_of_books poa_gl

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
1392: and Trunc(ptmp.creation_date) <= nvl(l.expiration_date, ptmp.creation_date)

Line 1877: gl_sets_of_books poa_gl,

1873: poa_dbi_pod_inc inc,
1874: poa_dbi_neg_details negd,
1875: poa_dbi_pod_rates rat,
1876: po_doc_style_headers style,
1877: gl_sets_of_books poa_gl,
1878: ( select /*+ PARALLEL(a) PARALLEL(pod) NO_MERGE */
1879: pod.po_distribution_id,
1880: pod.creation_date,
1881: pod.req_distribution_id,

Line 2159: gl_sets_of_books poa_gl,

2155: FROM
2156: poa_dbi_pod_inc inc,
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,