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_FACT_DETAILS

Line 16: FROM csd_fact_details

12: BEGIN
13:
14: SELECT last_run_date
15: INTO l_last_run_date
16: FROM csd_fact_details
17: WHERE fact_name = p_fact_name;
18:
19: RETURN l_last_run_date;
20:

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

137: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
138:
139: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Repair Orders fact ...');
140:
141: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_REPAIR_ORDERS_F name ...');
142:
143: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_REPAIR_ORDERS_F;
144:
145: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 143: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_REPAIR_ORDERS_F;

139: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Repair Orders fact ...');
140:
141: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_REPAIR_ORDERS_F name ...');
142:
143: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_REPAIR_ORDERS_F;
144:
145: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
146:
147: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_REPAIR_ORDERS_F ...');

Line 199: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

195: AND UOM.uom_code = RO.unit_of_measure;
196:
197: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
198:
199: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
200:
201: INSERT INTO CSD_FACT_DETAILS
202: (fact_name,
203: last_run_date,

Line 201: INSERT INTO CSD_FACT_DETAILS

197: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
198:
199: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
200:
201: INSERT INTO CSD_FACT_DETAILS
202: (fact_name,
203: last_run_date,
204: created_by,
205: creation_date,

Line 337: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');

333: l_request_id);
334:
335: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merge complete.');
336:
337: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');
338:
339: UPDATE CSD_FACT_DETAILS
340: SET last_run_date = l_run_date,
341: last_update_date = sysdate,

Line 339: UPDATE CSD_FACT_DETAILS

335: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merge complete.');
336:
337: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');
338:
339: UPDATE CSD_FACT_DETAILS
340: SET last_run_date = l_run_date,
341: last_update_date = sysdate,
342: last_updated_by = l_user_id,
343: last_update_login = l_login_id,

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

397: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
398:
399: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Materials Consumed fact ...');
400:
401: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_MTL_CONSUMED_F name ...');
402:
403: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_MTL_CONSUMED_F;
404:
405: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 403: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_MTL_CONSUMED_F;

399: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Materials Consumed fact ...');
400:
401: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_MTL_CONSUMED_F name ...');
402:
403: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_MTL_CONSUMED_F;
404:
405: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
406:
407: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_MTL_CONSUMED_F ...');

Line 472: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

468: MSI.primary_uom_code;
469:
470: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
471:
472: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
473:
474: INSERT INTO CSD_FACT_DETAILS
475: (fact_name,
476: last_run_date,

Line 474: INSERT INTO CSD_FACT_DETAILS

470: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
471:
472: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
473:
474: INSERT INTO CSD_FACT_DETAILS
475: (fact_name,
476: last_run_date,
477: created_by,
478: creation_date,

Line 618: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');

614: l_request_id);
615:
616: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merge complete.');
617:
618: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');
619:
620: UPDATE CSD_FACT_DETAILS
621: SET last_run_date = l_run_date,
622: last_update_date = sysdate,

Line 620: UPDATE CSD_FACT_DETAILS

616: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merge complete.');
617:
618: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');
619:
620: UPDATE CSD_FACT_DETAILS
621: SET last_run_date = l_run_date,
622: last_update_date = sysdate,
623: last_updated_by = l_user_id,
624: last_update_login = l_login_id,

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 741: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

737: GROUP BY RO.repair_line_id, WTXN.primary_uom, WTXN.resource_id;
738:
739: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
740:
741: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
742:
743: INSERT INTO CSD_FACT_DETAILS
744: (fact_name,
745: last_run_date,

Line 743: INSERT INTO CSD_FACT_DETAILS

739: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
740:
741: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
742:
743: INSERT INTO CSD_FACT_DETAILS
744: (fact_name,
745: last_run_date,
746: created_by,
747: creation_date,

Line 875: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');

871: l_request_id);
872:
873: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merge complete.');
874:
875: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');
876:
877: UPDATE CSD_FACT_DETAILS
878: SET last_run_date = l_run_date,
879: last_update_date = sysdate,

Line 877: UPDATE CSD_FACT_DETAILS

873: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merge complete.');
874:
875: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Updating CSD_FACT_DETAILS ...');
876:
877: UPDATE CSD_FACT_DETAILS
878: SET last_run_date = l_run_date,
879: last_update_date = sysdate,
880: last_updated_by = l_user_id,
881: last_update_login = l_login_id,