APPS.POA_DBI_PO_DIST_F_C dependencies on POA_DBI_POD_LOWEST_PRICE_TEMP

Line 37: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_LOWEST_PRICE_TEMP';

33:
34: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_LOWEST_ALL_TEMP';
35: EXECUTE IMMEDIATE l_stmt;
36:
37: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_LOWEST_PRICE_TEMP';
38: EXECUTE IMMEDIATE l_stmt;
39:
40: g_init := true;
41: populate_po_dist_facts (errbuf, retcode);

Line 1522: insert /*+ APPEND PARALLEL(t) */ into poa_dbi_pod_lowest_price_temp t(po_distribution_id,

1518:
1519: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1520: TABNAME => 'POA_DBI_POD_LOWEST_ALL_TEMP') ;
1521:
1522: insert /*+ APPEND PARALLEL(t) */ into poa_dbi_pod_lowest_price_temp t(po_distribution_id,
1523: lowest_price,
1524: potential_contract_id)
1525: select po_distribution_id,
1526: coalesce(min(shipto_price), min(generic_price), min(unit_price)) lowest_price,

Line 1536: TABNAME => 'POA_DBI_POD_LOWEST_PRICE_TEMP') ;

1532:
1533: COMMIT;
1534:
1535: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1536: TABNAME => 'POA_DBI_POD_LOWEST_PRICE_TEMP') ;
1537:
1538: bis_collection_utilities.log('Initial Load - using one batch approach, populate base fact. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1539: INSERT /*+ APPEND PARALLEL(t) */ INTO
1540: poa_dbi_pod_f t

Line 1934: poa_dbi_pod_lowest_price_temp low,

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,
1938: po_headers_all ref,