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_MTL_CONSUMED_F

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 407: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_MTL_CONSUMED_F ...');

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 ...');
408:
409: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_MTL_CONSUMED_F');
410:
411: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 409: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_MTL_CONSUMED_F');

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 ...');
408:
409: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_MTL_CONSUMED_F');
410:
411: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
412:
413: l_run_date := sysdate - 5 / (24 * 60);

Line 415: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_MTL_CONSUMED_F ...');

411: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
412:
413: l_run_date := sysdate - 5 / (24 * 60);
414:
415: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_MTL_CONSUMED_F ...');
416:
417: INSERT INTO CSD_MTL_CONSUMED_F
418: (repair_line_id,
419: inventory_item_id,

Line 417: INSERT INTO CSD_MTL_CONSUMED_F

413: l_run_date := sysdate - 5 / (24 * 60);
414:
415: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_MTL_CONSUMED_F ...');
416:
417: INSERT INTO CSD_MTL_CONSUMED_F
418: (repair_line_id,
419: inventory_item_id,
420: primary_quantity,
421: primary_uom_code,

Line 487: (C_CSD_MTL_CONSUMED_F,

483: program_login_id,
484: program_application_id,
485: request_id)
486: VALUES
487: (C_CSD_MTL_CONSUMED_F,
488: l_run_date,
489: l_user_id,
490: sysdate,
491: sysdate,

Line 550: l_last_run_date := get_last_run_date(C_CSD_MTL_CONSUMED_F);

546: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Materials Consumed fact ...');
549:
550: l_last_run_date := get_last_run_date(C_CSD_MTL_CONSUMED_F);
551:
552: l_run_date := sysdate - 5 / (24 * 60);
553:
554: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_MTL_CONSUMED_F ...');

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

550: l_last_run_date := get_last_run_date(C_CSD_MTL_CONSUMED_F);
551:
552: l_run_date := sysdate - 5 / (24 * 60);
553:
554: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_MTL_CONSUMED_F ...');
555:
556: MERGE INTO CSD_MTL_CONSUMED_F fact
557: USING (SELECT RO.repair_line_id,
558: mmt.inventory_item_id INVENTORY_ITEM_ID,

Line 556: MERGE INTO CSD_MTL_CONSUMED_F fact

552: l_run_date := sysdate - 5 / (24 * 60);
553:
554: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_MTL_CONSUMED_F ...');
555:
556: MERGE INTO CSD_MTL_CONSUMED_F fact
557: USING (SELECT RO.repair_line_id,
558: mmt.inventory_item_id INVENTORY_ITEM_ID,
559: CEIL(SUM(DECODE(MMT.transaction_type_id,
560: lc_MTL_TXN_TYPE_COMP_ISSUE,

Line 629: WHERE fact_name = C_CSD_MTL_CONSUMED_F;

625: program_id = l_program_id,
626: program_login_id = l_program_login_id,
627: program_application_id = l_program_application_id,
628: request_id = l_request_id
629: WHERE fact_name = C_CSD_MTL_CONSUMED_F;
630:
631: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Update complete.');
632:
633: commit;