APPS.POA_DBI_PO_DIST_F_C dependencies on POA_DBI_POD_MATCH_TEMP

Line 31: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_MATCH_TEMP';

27:
28: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_NEG_DETAILS';
29: EXECUTE IMMEDIATE l_stmt;
30:
31: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_MATCH_TEMP';
32: EXECUTE IMMEDIATE l_stmt;
33:
34: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_POD_LOWEST_ALL_TEMP';
35: EXECUTE IMMEDIATE l_stmt;

Line 1222: INSERT /*+ APPEND PARALLEL(poa_dbi_pod_match_temp) */ INTO

1218: if (l_no_batch is NOT NULL) then
1219: IF (g_init) THEN
1220: bis_collection_utilities.log('Initial Load - populate match table. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1221:
1222: INSERT /*+ APPEND PARALLEL(poa_dbi_pod_match_temp) */ INTO
1223: poa_dbi_pod_match_temp
1224: ( po_distribution_id,
1225: creation_date,
1226: quantity,

Line 1223: poa_dbi_pod_match_temp

1219: IF (g_init) THEN
1220: bis_collection_utilities.log('Initial Load - populate match table. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1221:
1222: INSERT /*+ APPEND PARALLEL(poa_dbi_pod_match_temp) */ INTO
1223: poa_dbi_pod_match_temp
1224: ( po_distribution_id,
1225: creation_date,
1226: quantity,
1227: unit_meas_lookup_code,

Line 1363: TABNAME => 'POA_DBI_POD_MATCH_TEMP') ;

1359:
1360: COMMIT;
1361:
1362: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_poa_schema,
1363: TABNAME => 'POA_DBI_POD_MATCH_TEMP') ;
1364:
1365: bis_collection_utilities.log('Initial Load - populate lowest price table. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1366:
1367: INSERT /*+ APPEND PARALLEL(t) */ INTO poa_dbi_pod_lowest_all_temp t(po_distribution_id, po_header_id, shipto_price, generic_price, unit_price)

Line 1377: poa_dbi_pod_match_temp ptmp,

1373: l.creation_date bl_creation_date,
1374: nvl(std.po_line_id, l.po_line_id) std_id,
1375: poa_gl.currency_code bl_func_cur_code, b.rate bl_rate
1376: from po_headers_all b,
1377: poa_dbi_pod_match_temp ptmp,
1378: po_lines_all std,
1379: (select /*+ PARALLEL(bl) no_merge */ bl.po_header_id, bl.item_id, bl.unit_meas_lookup_code,bl.expiration_date, bl.po_line_id, bl.min_release_amount, bl.unit_price, bl.cancel_flag, bl.price_break_lookup_code, bl.creation_date
1380: from po_lines_all bl
1381: where bl.price_break_lookup_code is not null

Line 1494: poa_dbi_pod_match_temp ptmp3,

1490: and nvl(rd.distribution_type,'-99') <> 'AGREEMENT'
1491: and (rll.shipment_type is null or rll.shipment_type in ('BLANKET', 'STANDARD', 'PRICE BREAK'))
1492: GROUP by b.po_distribution_id, b.po_header_id
1493: ) bblanket,
1494: poa_dbi_pod_match_temp ptmp3,
1495: po_line_locations_all pb
1496: where blanket.po_distribution_id = ptmp3.po_distribution_id
1497: and blanket.po_distribution_id = bblanket.po_distribution_id
1498: and blanket.po_header_id = bblanket.po_header_id

Line 1935: poa_dbi_pod_match_temp match,

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,
1939: po_requisition_headers_all prh,