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 POA_DBI_POD_INC

Line 19: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';

15: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
16: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_F';
17: EXECUTE IMMEDIATE l_stmt;
18:
19: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';
20: EXECUTE IMMEDIATE l_stmt;
21:
22: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_RATES';
23: EXECUTE IMMEDIATE l_stmt;

Line 149: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';

145: IF (NOT(FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema))) THEN
146: bis_collection_utilities.log('Error getting app info '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
147: RAISE_APPLICATION_ERROR (-20000, 'Error in GET_APP_INFO: ' || errbuf);
148: END IF;
149: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_INC';
150: EXECUTE IMMEDIATE l_stmt;
151: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_RATES';
152: EXECUTE IMMEDIATE l_stmt;
153: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_PO_RATES';

Line 164: insert /+ append parallel(poa_dbi_pod_inc) / into poa_dbi_pod_inc

160: l_glob_date := To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS');
161: d_glob_date := bis_common_parameters.get_global_start_date;
162:
163: if(g_init) then
164: insert /*+ append parallel(poa_dbi_pod_inc) */ into poa_dbi_pod_inc
165: ( primary_key,
166: global_cur_conv_rate,
167: batch_id,
168: func_cur_code,

Line 243: poa_dbi_pod_inc

239:
240: else -- not initial load
241:
242: insert /*+ append */ into
243: poa_dbi_pod_inc
244: (
245: primary_key,
246: global_cur_conv_rate,
247: batch_id,

Line 450: fnd_stats.gather_table_stats(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_POD_INC');

446: COMMIT;
447:
448: DBMS_APPLICATION_INFO.SET_ACTION('stats incremental');
449:
450: fnd_stats.gather_table_stats(OWNNAME => l_poa_schema, TABNAME => 'POA_DBI_POD_INC');
451:
452: insert /*+ APPEND */ into poa_dbi_pod_rates
453: (
454: txn_cur_code,

Line 486: from poa_dbi_pod_inc

482: select distinct
483: txn_cur_code,
484: func_cur_code,
485: rate_date
486: from poa_dbi_pod_inc
487: order by func_cur_code, rate_date
488: );
489:
490: COMMIT;

Line 527: from poa_dbi_pod_inc inc,

523: select /*+ parallel(pod) parallel(pol) parallel(ponh) parallel(ponbh) */
524: distinct ponh.currency_code txn_cur_code,
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,

Line 547: from poa_dbi_pod_inc inc,

543: select /*+ parallel(pod) parallel(pol) parallel(ponh) parallel(ponbh) */
544: distinct ponh.currency_code txn_cur_code,
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,

Line 568: poa_dbi_pod_inc inc,

564: distinct ponh.currency_code txn_cur_code,
565: pgl.currency_code func_cur_code,
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,

Line 620: from poa_dbi_pod_inc inc,

616: select /*+ leading(inc,pod) cardinality(inc,1) */
617: distinct ponh.currency_code txn_cur_code,
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,

Line 640: from poa_dbi_pod_inc inc,

636: select /*+ leading(inc,pod) cardinality(inc,100) */
637: distinct ponh.currency_code txn_cur_code,
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,

Line 661: poa_dbi_pod_inc inc,

657: distinct ponh.currency_code txn_cur_code,
658: pgl.currency_code func_cur_code,
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,

Line 736: poa_dbi_pod_inc inc,

732: )
733: )
734: ) neg_base_uom_conv_rate
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,

Line 811: poa_dbi_pod_inc inc,

807: )
808: )
809: ) neg_base_uom_conv_rate
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,

Line 891: poa_dbi_pod_inc inc,

887: )
888: )
889: ) neg_base_uom_conv_rate
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,

Line 982: poa_dbi_pod_inc inc,

978: )
979: )
980: ) neg_base_uom_conv_rate
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,

Line 1057: poa_dbi_pod_inc inc,

1053: )
1054: )
1055: ) neg_base_uom_conv_rate
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,

Line 1137: poa_dbi_pod_inc inc,

1133: )
1134: )
1135: ) neg_base_uom_conv_rate
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,

Line 1191: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_pod_inc;

1187: TABNAME => 'POA_DBI_NEG_DETAILS') ;
1188:
1189: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1190:
1191: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_pod_inc;
1192: bis_collection_utilities.log('Identified '|| l_count ||' changed records. Batch size='|| l_batch_size || '. # of Batches=' || l_no_batch
1193: || '. Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1194:
1195: /* missing currency handling */

Line 1257: poa_dbi_pod_inc inc,

1253: match.ship_to_ou_id,
1254: pol.category_id,
1255: pll.ship_to_organization_id
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,

Line 1274: poa_dbi_pod_inc inc,

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
1278: hro.org_information_context='Accounting Information') hro,

Line 1873: poa_dbi_pod_inc inc,

1869: negd.neg_base_uom,
1870: negd.neg_base_uom_conv_rate,
1871: nvl(pol.negotiated_by_preparer_flag,'N') negotiated_by_preparer_flag
1872: FROM
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,

Line 2156: poa_dbi_pod_inc inc,

2152: negd.neg_base_uom,
2153: negd.neg_base_uom_conv_rate,
2154: nvl(pol.negotiated_by_preparer_flag,'N') negotiated_by_preparer_flag
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,

Line 2180: poa_dbi_pod_inc inc,

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
2184: hro.org_information_context='Accounting Information') hro,

Line 2545: where f.po_distribution_id in (select primary_key from poa_dbi_pod_inc

2541: ,po_distributions_all pod
2542: where pod.po_distribution_id = f.po_distribution_id
2543: and pll.line_location_id = pod.line_location_id
2544: and pll.approved_date >= pod.creation_date)
2545: where f.po_distribution_id in (select primary_key from poa_dbi_pod_inc
2546: where batch_id = v_batch_no);
2547: COMMIT;
2548: DBMS_APPLICATION_INFO.SET_ACTION('EAD batch ' || v_batch_no || ' done');
2549: END LOOP;