APPS.OPI_DBI_RES_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 40: --ETL ID for OPI_DBI_RUN_LOG_CURR

36: OPM_SOURCE CONSTANT NUMBER := 2;
37: PRE_R12_OPM_SOURCE CONSTANT NUMBER := 3;
38:
39:
40: --ETL ID for OPI_DBI_RUN_LOG_CURR
41:
42: -- Actual Resource Usage
43: ACTUAL_RES_ETL CONSTANT NUMBER :=
44: opi_dbi_common_mod_init_pkg.ACTUAL_RES_ETL;

Line 803: opi_dbi_run_log_curr rlc,

799: wip_transaction_accounts wta,
800: wip_entities we,
801: mtl_uom_conversions m,
802: mtl_uom_conversions m2,
803: opi_dbi_run_log_curr rlc,
804: bom_department_resources bdr
805: WHERE
806: -- 1->resource trx 3-> outside processing,
807: -- both involve resource, other types don't have resource_id

Line 1090: SELECT /*+ ordered use_nl(rlc wt) index(rlc, OPI_DBI_RUN_LOG_CURR_N1)

1086: source,
1087: job_id,
1088: job_type,
1089: assembly_item_id)
1090: SELECT /*+ ordered use_nl(rlc wt) index(rlc, OPI_DBI_RUN_LOG_CURR_N1)
1091: index(wt, WIP_TRANSACTIONS_U1) index(wta, WIP_TRANSACTION_ACCOUNTS_N1)
1092: use_nl(we) index(we, WE_C1) index(bdr, BOM_DEPARTMENT_RESOURCES_U1)
1093: use_nl(bdr) use_nl(m) use_nl(m2) */
1094: wt.resource_id,

Line 1112: opi_dbi_run_log_curr rlc,

1108: wt.primary_item_id assembly_item_id
1109: FROM wip_transactions wt,
1110: wip_transaction_accounts wta,
1111: wip_entities we,
1112: opi_dbi_run_log_curr rlc,
1113: bom_department_resources bdr,
1114: mtl_uom_conversions m,
1115: mtl_uom_conversions m2
1116: WHERE

Line 1232: opi_dbi_run_log_curr log,

1228: SELECT gtv.transaction_id,
1229: gtv.accounted_flag,
1230: gtv.txn_base_value
1231: FROM gmf_transaction_valuation gtv,
1232: opi_dbi_run_log_curr log,
1233: opi_dbi_org_le_temp tmp
1234: WHERE nvl(gtv.accounted_flag, 'F') <> 'N'
1235: AND gtv.journal_line_type = 'WIP'
1236: AND gtv.event_class_code = 'BATCH_RESOURCE'

Line 1501: opi_dbi_run_log_curr log,

1497: SELECT gtv.transaction_id,
1498: gtv.accounted_flag,
1499: gtv.txn_base_value
1500: FROM gmf_transaction_valuation gtv,
1501: opi_dbi_run_log_curr log,
1502: opi_dbi_org_le_temp tmp
1503: WHERE gtv.accounted_flag is NULL
1504: AND gtv.journal_line_type = 'WIP'
1505: AND gtv.event_class_code = 'BATCH_RESOURCE'

Line 2198: l_opm_start_date opi_dbi_run_log_curr.from_bound_date%type;

2194:
2195: l_opi_start_date DATE;
2196: l_opi_end_date DATE;
2197:
2198: l_opm_start_date opi_dbi_run_log_curr.from_bound_date%type;
2199: l_opm_end_date opi_dbi_run_log_curr.to_bound_date%type;
2200:
2201: l_r12_mgr_date opi_dbi_conc_prog_run_log.last_run_date%type;
2202:

Line 2199: l_opm_end_date opi_dbi_run_log_curr.to_bound_date%type;

2195: l_opi_start_date DATE;
2196: l_opi_end_date DATE;
2197:
2198: l_opm_start_date opi_dbi_run_log_curr.from_bound_date%type;
2199: l_opm_end_date opi_dbi_run_log_curr.to_bound_date%type;
2200:
2201: l_r12_mgr_date opi_dbi_conc_prog_run_log.last_run_date%type;
2202:
2203: SCHEMA_INFO_NOT_FOUND exception;

Line 2332: FROM opi_dbi_run_log_curr

2328:
2329: BEGIN
2330: SELECT trunc(from_bound_date), trunc(to_bound_date)
2331: INTO l_opi_start_date, l_opi_end_date
2332: FROM opi_dbi_run_log_curr
2333: WHERE etl_id = RESOURCE_VAR_ETL
2334: AND source = OPI_SOURCE;
2335:
2336: EXCEPTION

Line 2346: FROM opi_dbi_run_log_curr

2342:
2343: BEGIN
2344: SELECT trunc(from_bound_date), trunc(to_bound_date)
2345: INTO l_opm_start_date, l_opm_end_date
2346: FROM opi_dbi_run_log_curr
2347: WHERE etl_id = RESOURCE_VAR_ETL
2348: AND source = OPM_SOURCE;
2349:
2350: EXCEPTION

Line 2903: l_opm_start_date opi_dbi_run_log_curr.from_bound_date%type;

2899:
2900: l_opi_start_date DATE;
2901: l_opi_end_date DATE;
2902:
2903: l_opm_start_date opi_dbi_run_log_curr.from_bound_date%type;
2904: l_opm_end_date opi_dbi_run_log_curr.to_bound_date%type;
2905:
2906: SCHEMA_INFO_NOT_FOUND exception;
2907: NO_DATA_FOUND exception;

Line 2904: l_opm_end_date opi_dbi_run_log_curr.to_bound_date%type;

2900: l_opi_start_date DATE;
2901: l_opi_end_date DATE;
2902:
2903: l_opm_start_date opi_dbi_run_log_curr.from_bound_date%type;
2904: l_opm_end_date opi_dbi_run_log_curr.to_bound_date%type;
2905:
2906: SCHEMA_INFO_NOT_FOUND exception;
2907: NO_DATA_FOUND exception;
2908:

Line 3053: FROM opi_dbi_run_log_curr

3049:
3050: BEGIN
3051: SELECT trunc(from_bound_date), trunc(to_bound_date)
3052: INTO l_opi_start_date, l_opi_end_date
3053: FROM opi_dbi_run_log_curr
3054: WHERE etl_id = RESOURCE_VAR_ETL
3055: AND source = OPI_SOURCE;
3056:
3057: EXCEPTION

Line 3067: FROM opi_dbi_run_log_curr

3063:
3064: BEGIN
3065: SELECT trunc(from_bound_date), trunc(to_bound_date)
3066: INTO l_opm_start_date, l_opm_end_date
3067: FROM opi_dbi_run_log_curr
3068: WHERE etl_id = RESOURCE_VAR_ETL
3069: AND source = OPM_SOURCE;
3070:
3071: EXCEPTION