APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on OPI_DBI_JOBS_STG

Line 1016: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_STG';

1012: /* Truncating Jobs Staging Table */
1013: l_stmt_num := 30;
1014: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
1015: --{
1016: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_STG';
1017: --}
1018: END IF;
1019:
1020: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);

Line 1153: FROM OPI_DBI_JOBS_STG jobs

1149: , WPB.TL_RESOURCE_IN
1150: , WPB.TL_RESOURCE_OUT
1151: , WPB.TL_SCRAP_IN
1152: , WPB.TL_SCRAP_OUT
1153: FROM OPI_DBI_JOBS_STG jobs
1154: , WIP_PERIOD_BALANCES wpb
1155: WHERE jobs.Status = 'Closed'
1156: AND jobs.ORGANIZATION_ID = wpb.ORGANIZATION_ID
1157: AND wpb.CLASS_TYPE IN (1, 5)

Line 1190: FROM OPI_DBI_JOBS_STG jobs

1186: , WPB.TL_RESOURCE_IN
1187: , WPB.TL_RESOURCE_OUT
1188: , WPB.TL_SCRAP_IN
1189: , WPB.TL_SCRAP_OUT
1190: FROM OPI_DBI_JOBS_STG jobs
1191: , WIP_PERIOD_BALANCES wpb
1192: WHERE jobs.Status = 'Closed'
1193: AND jobs.ORGANIZATION_ID = wpb.ORGANIZATION_ID
1194: AND wpb.CLASS_TYPE = 2

Line 1345: OPI_DBI_JOBS_STG jobs,

1341: jobs.uom_code,
1342: mtl_dtl.Line_type,
1343: jobs.organization_id
1344: from
1345: OPI_DBI_JOBS_STG jobs,
1346: GME_MATERIAL_DETAILS mtl_dtl
1347: where
1348: jobs.job_id = mtl_dtl.batch_id and
1349: jobs.organization_id = mtl_dtl.organization_id and

Line 1367: OPI_DBI_JOBS_STG jobs,

1363: jobs.uom_code,
1364: -1 Line_type,
1365: jobs.Organization_id
1366: from
1367: OPI_DBI_JOBS_STG jobs,
1368: GME_BATCH_STEP_RESOURCES gbsr
1369: where
1370: jobs.job_id = gbsr.batch_id and
1371: jobs.source = 2 and

Line 1486: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_STG';

1482: /* Truncating Jobs Staging Table */
1483: l_stmt_num := 30;
1484: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
1485: --{
1486: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_STG';
1487: --}
1488: END IF;
1489:
1490: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);