APPS.OPI_DBI_INV_CPCS_PKG dependencies on OPI_DBI_ONHAND_STG

Line 31: '.OPI_DBI_ONHAND_STG';

27:
28: IF (fnd_installation.get_app_info( 'OPI', l_status,
29: l_industry, l_opi_schema)) THEN
30: execute immediate 'truncate table ' || l_opi_schema ||
31: '.OPI_DBI_ONHAND_STG';
32: BIS_COLLECTION_UTILITIES.put_line(
33: 'OPI_DBI_ONHAND_STG table truncated.');
34:
35: execute immediate 'truncate table ' || l_opi_schema ||

Line 33: 'OPI_DBI_ONHAND_STG table truncated.');

29: l_industry, l_opi_schema)) THEN
30: execute immediate 'truncate table ' || l_opi_schema ||
31: '.OPI_DBI_ONHAND_STG';
32: BIS_COLLECTION_UTILITIES.put_line(
33: 'OPI_DBI_ONHAND_STG table truncated.');
34:
35: execute immediate 'truncate table ' || l_opi_schema ||
36: '.OPI_DBI_INTRANSIT_STG';
37: BIS_COLLECTION_UTILITIES.put_line (

Line 123: FROM opi_dbi_onhand_stg

119: transaction_date,
120: onhand_value_b,
121: 0 intransit_value_b,
122: 0 wip_value_b
123: FROM opi_dbi_onhand_stg
124: WHERE source = g_opi_cpcs_source
125: UNION ALL
126: SELECT /*+ parallel(intransit_stg) */
127: organization_id,

Line 367: INSERT /*+ append parallel(opi_dbi_onhand_stg)

363: 'Started First Period Close Adjustments load.');
364: BIS_COLLECTION_UTILITIES.put_line('(First period closed with the FP "J"/115.10, period close process.)');
365:
366: l_stmt_num := 30;
367: INSERT /*+ append parallel(opi_dbi_onhand_stg)
368: parallel(opi_dbi_intransit_stg) */
369: ALL
370: WHEN onhand_value_lump_Sum <> 0
371: THEN INTO opi_dbi_onhand_stg

Line 371: THEN INTO opi_dbi_onhand_stg

367: INSERT /*+ append parallel(opi_dbi_onhand_stg)
368: parallel(opi_dbi_intransit_stg) */
369: ALL
370: WHEN onhand_value_lump_Sum <> 0
371: THEN INTO opi_dbi_onhand_stg
372: (organization_id, inventory_item_id, transaction_date,
373: onhand_value_b, source, subinventory_code,
374: creation_date, last_update_date, created_by,
375: last_updated_by, last_update_login)

Line 599: THEN INTO opi_dbi_onhand_stg

595: BIS_COLLECTION_UTILITIES.put_line('Started Period Close Regular Adjustments load.');
596:
597: INSERT ALL
598: WHEN onhand_value_b <> 0
599: THEN INTO opi_dbi_onhand_stg
600: (organization_id, inventory_item_id, transaction_date,
601: onhand_value_b, source, subinventory_code,
602: creation_date, last_update_date, created_by,
603: last_updated_by, last_update_login)