APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on OPI_DBI_OPM_SCALED_MTL

Line 1549: OPI_DBI_OPM_SCALED_MTL scaled,

1545: s_program_login_id,
1546: s_program_application_id,
1547: s_request_id
1548: from
1549: OPI_DBI_OPM_SCALED_MTL scaled,
1550: gme_material_details coprod,
1551: gl_subr_led led,
1552: (
1553: SELECT

Line 2642: OPI_DBI_OPM_SCALED_MTL tmp,

2638: s_program_login_id,
2639: s_program_application_id,
2640: s_request_id
2641: from
2642: OPI_DBI_OPM_SCALED_MTL tmp,
2643: (
2644: select
2645: job_id,
2646: job_type,

Line 2757: OPI_DBI_OPM_SCALED_MTL tmp,

2753: s_program_login_id PROGRAM_LOGIN_ID,
2754: s_program_application_id PROGRAM_APPLICATION_ID,
2755: s_request_id REQUEST_ID
2756: from
2757: OPI_DBI_OPM_SCALED_MTL tmp,
2758: (
2759: select
2760: job_id,
2761: job_type,

Line 2877: Procedure populates temp table OPI_DBI_OPM_SCALED_MTL used to get the planned_qty for OPM,

2873:
2874: END GET_OPI_OPM_MTL_USAGE_STD_INCR;
2875:
2876: /*
2877: Procedure populates temp table OPI_DBI_OPM_SCALED_MTL used to get the planned_qty for OPM,
2878: Initial Load procedure
2879:
2880: Parameters:
2881: retcode - 0 on successful completion, -1 on error and 1 for warning.

Line 2987: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';

2983: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2984:
2985: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
2986: --{
2987: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';
2988: --}
2989: END IF;
2990:
2991: l_stmt_num := 10;

Line 3050: INSERT INTO OPI_DBI_OPM_SCALED_MTL

3046: --}
3047: end if;
3048:
3049:
3050: INSERT INTO OPI_DBI_OPM_SCALED_MTL
3051: (
3052: ORGANIZATION_ID ,
3053: JOB_TYPE,
3054: BATCH_ID,

Line 3109: select count(*) into l_row_count from OPI_DBI_OPM_SCALED_MTL;

3105: END LOOP;
3106:
3107: commit;
3108:
3109: select count(*) into l_row_count from OPI_DBI_OPM_SCALED_MTL;
3110:
3111: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Scaled Extraction: '|| l_row_count || ' rows inserted');
3112: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3113:

Line 3130: Procedurr populates temp table OPI_DBI_OPM_SCALED_MTL used to get the planned_qty for OPM,

3126:
3127: END GET_OPI_SCALED_MTL_INIT;
3128:
3129: /*
3130: Procedurr populates temp table OPI_DBI_OPM_SCALED_MTL used to get the planned_qty for OPM,
3131: Incremental Load procedure
3132:
3133: Parameters:
3134: retcode - 0 on successful completion, -1 on error and 1 for warning.

Line 3241: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';

3237: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3238:
3239: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
3240: --{
3241: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';
3242: --}
3243: END IF;
3244:
3245: l_stmt_num := 10;

Line 3303: INSERT INTO OPI_DBI_OPM_SCALED_MTL

3299: l_scale_qty := l_scale_tab(i).qty;
3300: --}
3301: end if;
3302:
3303: INSERT INTO OPI_DBI_OPM_SCALED_MTL
3304: (
3305: ORGANIZATION_ID ,
3306: JOB_TYPE,
3307: BATCH_ID,

Line 3362: select count(*) into l_row_count from OPI_DBI_OPM_SCALED_MTL;

3358: END LOOP;
3359:
3360: commit;
3361:
3362: select count(*) into l_row_count from OPI_DBI_OPM_SCALED_MTL;
3363:
3364: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Scaled Extraction: '|| l_row_count || ' rows inserted');
3365: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3366:

Line 4009: --execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';

4005: /* truncate all tables */
4006: l_stmt_num := 10;
4007: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
4008: --{
4009: --execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';
4010: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_STD_QTY_TMP';
4011: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_TXN_STG';
4012: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_TXN_MMT_STG';
4013: execute immediate 'truncate table ' || l_opi_schema || '.opi_dbi_muv_conv_rates';