eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_RES_PKG dependencies on OPI_DBI_RES_AVAIL_STG

Line 335: SELECT /+ parallel (opi_dbi_res_avail_stg) /

331: organization_id,
332: transaction_date
333: FROM opi_dbi_res_actual_stg
334: UNION
335: SELECT /*+ parallel (opi_dbi_res_avail_stg) */
336: DISTINCT
337: organization_id,
338: transaction_date
339: FROM opi_dbi_res_avail_stg) to_conv

Line 339: FROM opi_dbi_res_avail_stg) to_conv

335: SELECT /*+ parallel (opi_dbi_res_avail_stg) */
336: DISTINCT
337: organization_id,
338: transaction_date
339: FROM opi_dbi_res_avail_stg) to_conv
340: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
341: AND mp.organization_id = to_conv.organization_id
342: AND conv.transaction_date (+) = to_conv.transaction_date
343: AND conv.organization_id (+) = to_conv.organization_id

Line 366: SELECT /+ parallel (opi_dbi_res_avail_stg) /

362: organization_id,
363: transaction_date
364: FROM opi_dbi_res_actual_stg
365: UNION
366: SELECT /*+ parallel (opi_dbi_res_avail_stg) */
367: DISTINCT
368: organization_id,
369: transaction_date
370: FROM opi_dbi_res_avail_stg) to_conv

Line 370: FROM opi_dbi_res_avail_stg) to_conv

366: SELECT /*+ parallel (opi_dbi_res_avail_stg) */
367: DISTINCT
368: organization_id,
369: transaction_date
370: FROM opi_dbi_res_avail_stg) to_conv
371: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
372: AND mp.organization_id = to_conv.organization_id
373: AND conv.transaction_date (+) = to_conv.transaction_date
374: AND conv.organization_id (+) = to_conv.organization_id)

Line 460: SELECT /+ parallel (opi_dbi_res_avail_stg) /

456: organization_id,
457: trunc (transaction_date) transaction_date
458: FROM opi_dbi_res_actual_stg
459: UNION
460: SELECT /*+ parallel (opi_dbi_res_avail_stg) */
461: DISTINCT
462: organization_id,
463: trunc (transaction_date) transaction_date
464: FROM opi_dbi_res_avail_stg) to_conv,

Line 464: FROM opi_dbi_res_avail_stg) to_conv,

460: SELECT /*+ parallel (opi_dbi_res_avail_stg) */
461: DISTINCT
462: organization_id,
463: trunc (transaction_date) transaction_date
464: FROM opi_dbi_res_avail_stg) to_conv,
465: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
466: parallel (hoi) parallel (gsob)*/
467: DISTINCT
468: hoi.organization_id,

Line 586: INSERT /+ append parallel(e) / INTO opi_dbi_res_avail_stg (

582: l_stmt_num := 10;
583:
584: -- populate availability for 24 hr available resource
585:
586: INSERT /*+ append parallel(e) */ INTO opi_dbi_res_avail_stg (
587: resource_id,
588: department_id,
589: organization_id,
590: transaction_date,

Line 650: INSERT /+ append / INTO opi_dbi_res_avail_stg (

646:
647: l_stmt_num := 20;
648: -- populate availability for shift based resource
649:
650: INSERT /*+ append */ INTO opi_dbi_res_avail_stg (
651: resource_id,
652: department_id,
653: organization_id,
654: transaction_date,

Line 900: INSERT INTO opi_dbi_res_avail_stg (

896: END IF;
897:
898:
899: -- populate availability for 24 hr available resource
900: INSERT INTO opi_dbi_res_avail_stg (
901: resource_id,
902: department_id,
903: organization_id,
904: transaction_date,

Line 959: INSERT INTO opi_dbi_res_avail_stg (

955:
956: l_stmt_num := 20;
957: -- populate availability for shift based resource
958:
959: INSERT INTO opi_dbi_res_avail_stg (
960: resource_id,
961: department_id,
962: organization_id,
963: transaction_date,

Line 1317: INSERT /+ APPEND / INTO opi_dbi_res_avail_stg (

1313: l_stmt_num := 10;
1314:
1315: -- populate availability for opm resource
1316:
1317: INSERT /*+ APPEND */ INTO opi_dbi_res_avail_stg (
1318: resource_id,
1319: organization_id,
1320: department_id,
1321: transaction_date,

Line 1615: INSERT INTO opi_dbi_res_avail_stg (

1611:
1612:
1613: -- populate availability for opm resource
1614:
1615: INSERT INTO opi_dbi_res_avail_stg (
1616: resource_id,
1617: organization_id,
1618: department_id,
1619: transaction_date,

Line 2246: || '.opi_dbi_res_avail_stg ';

2242: execute immediate 'truncate table ' || l_opi_schema
2243: || '.opi_dbi_res_conv_rates ';
2244:
2245: execute immediate 'truncate table ' || l_opi_schema
2246: || '.opi_dbi_res_avail_stg ';
2247:
2248: execute immediate 'truncate table ' || l_opi_schema
2249: || '.opi_dbi_res_actual_stg ';
2250:

Line 2396: gather_stats(p_table_name => 'OPI_DBI_RES_AVAIL_STG');

2392: commit;
2393:
2394: gather_stats(p_table_name => 'OPI_DBI_RES_ACTUAL_STG');
2395:
2396: gather_stats(p_table_name => 'OPI_DBI_RES_AVAIL_STG');
2397:
2398: get_res_conversion_rate(errbuf => errbuf, retcode => retcode );
2399:
2400: commit;

Line 2618: FROM opi_dbi_res_avail_stg stg,

2614: NULL actual_val_b,
2615: NULL actual_val_g,
2616: NULL actual_val_sg,
2617: stg.source
2618: FROM opi_dbi_res_avail_stg stg,
2619: opi_dbi_res_conv_rates rate
2620: WHERE stg.organization_id = rate.organization_id
2621: AND stg.transaction_date = rate.transaction_date
2622: ) res

Line 2655: || '.opi_dbi_res_avail_stg ';

2651: execute immediate 'truncate table ' || l_opi_schema
2652: || '.opi_dbi_res_conv_rates ';
2653:
2654: execute immediate 'truncate table ' || l_opi_schema
2655: || '.opi_dbi_res_avail_stg ';
2656:
2657: execute immediate 'truncate table ' || l_opi_schema
2658: || '.opi_dbi_res_actual_stg ';
2659:

Line 3137: gather_stats(p_table_name => 'OPI_DBI_RES_AVAIL_STG');

3133: commit;
3134:
3135: gather_stats(p_table_name => 'OPI_DBI_RES_ACTUAL_STG');
3136:
3137: gather_stats(p_table_name => 'OPI_DBI_RES_AVAIL_STG');
3138:
3139: get_res_conversion_rate(errbuf => errbuf, retcode => retcode );
3140:
3141: commit;

Line 3359: opi_dbi_res_avail_stg stg,

3355: rate.conversion_rate conversion_rate,
3356: rate.sec_conversion_rate sec_conversion_rate,
3357: stg.source
3358: FROM
3359: opi_dbi_res_avail_stg stg,
3360: opi_dbi_res_conv_rates rate
3361: WHERE
3362: stg.organization_id = rate.organization_id
3363: AND stg.transaction_date = rate.transaction_date

Line 3486: || '.opi_dbi_res_avail_stg ';

3482: execute immediate 'truncate table ' || l_opi_schema
3483: || '.opi_dbi_res_conv_rates ';
3484:
3485: execute immediate 'truncate table ' || l_opi_schema
3486: || '.opi_dbi_res_avail_stg ';
3487:
3488: execute immediate 'truncate table ' || l_opi_schema
3489: || '.opi_dbi_res_actual_stg ';
3490: