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.CSD_HVR_BI_PVT dependencies on CSD_RES_CONSUMED_F

Line 682: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RES_CONSUMED_F name ...');

678: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
679:
680: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Resources Consumed fact ...');
681:
682: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RES_CONSUMED_F name ...');
683:
684: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RES_CONSUMED_F;
685:
686: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 684: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RES_CONSUMED_F;

680: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Resources Consumed fact ...');
681:
682: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RES_CONSUMED_F name ...');
683:
684: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RES_CONSUMED_F;
685:
686: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
687:
688: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RES_CONSUMED_F ...');

Line 688: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RES_CONSUMED_F ...');

684: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RES_CONSUMED_F;
685:
686: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
687:
688: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RES_CONSUMED_F ...');
689:
690: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RES_CONSUMED_F');
691:
692: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 690: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RES_CONSUMED_F');

686: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
687:
688: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RES_CONSUMED_F ...');
689:
690: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RES_CONSUMED_F');
691:
692: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
693:
694: l_run_date := sysdate - 5 / (24 * 60);

Line 696: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RES_CONSUMED_F ...');

692: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
693:
694: l_run_date := sysdate - 5 / (24 * 60);
695:
696: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RES_CONSUMED_F ...');
697:
698: INSERT INTO CSD_RES_CONSUMED_F
699: (repair_line_id,
700: resource_id,

Line 698: INSERT INTO CSD_RES_CONSUMED_F

694: l_run_date := sysdate - 5 / (24 * 60);
695:
696: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RES_CONSUMED_F ...');
697:
698: INSERT INTO CSD_RES_CONSUMED_F
699: (repair_line_id,
700: resource_id,
701: primary_quantity,
702: primary_uom_code,

Line 756: (C_CSD_RES_CONSUMED_F,

752: program_login_id,
753: program_application_id,
754: request_id)
755: VALUES
756: (C_CSD_RES_CONSUMED_F,
757: l_run_date,
758: l_user_id,
759: sysdate,
760: sysdate,

Line 819: l_last_run_date := get_last_run_date(C_CSD_RES_CONSUMED_F);

815: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Resources Consumed fact ...');
818:
819: l_last_run_date := get_last_run_date(C_CSD_RES_CONSUMED_F);
820:
821: l_run_date := sysdate - 5 / (24 * 60);
822:
823: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_RES_CONSUMED_F ...');

Line 823: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_RES_CONSUMED_F ...');

819: l_last_run_date := get_last_run_date(C_CSD_RES_CONSUMED_F);
820:
821: l_run_date := sysdate - 5 / (24 * 60);
822:
823: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_RES_CONSUMED_F ...');
824:
825: MERGE INTO CSD_RES_CONSUMED_F fact
826: USING (SELECT RO.repair_line_id,
827: WTXN.resource_id resource_id,

Line 825: MERGE INTO CSD_RES_CONSUMED_F fact

821: l_run_date := sysdate - 5 / (24 * 60);
822:
823: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_RES_CONSUMED_F ...');
824:
825: MERGE INTO CSD_RES_CONSUMED_F fact
826: USING (SELECT RO.repair_line_id,
827: WTXN.resource_id resource_id,
828: SUM(NVL(WTXN.primary_quantity, 0)) primary_quantity,
829: WTXN.primary_uom primary_uom_code

Line 886: WHERE fact_name = C_CSD_RES_CONSUMED_F;

882: program_id = l_program_id,
883: program_login_id = l_program_login_id,
884: program_application_id = l_program_application_id,
885: request_id = l_request_id
886: WHERE fact_name = C_CSD_RES_CONSUMED_F;
887:
888: FND_FILE.PUT_LINE(FND_FILE.LOG,lc_proc_name || ': ' || 'Update complete.');
889:
890: commit;