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.

[Home] [Help]

APPS.CSD_RETURNS_BI_PVT dependencies on CSD_RETURNS_BI_MTL_TXNS_F

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

534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
535:
536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');
537:
538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');
539:
540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;

536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');
537:
538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');
539:
540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');

Line 544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');

540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');
545:
546: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_MTL_TXNS_F');
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 546: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_MTL_TXNS_F');

542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');
545:
546: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_MTL_TXNS_F');
547:
548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
549:
550: l_run_date := sysdate - 5 / (24 * 60);

Line 552: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_MTL_TXNS_F ...');

548: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
549:
550: l_run_date := sysdate - 5 / (24 * 60);
551:
552: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_MTL_TXNS_F ...');
553:
554: INSERT INTO CSD_RETURNS_BI_MTL_TXNS_F
555: (transaction_id,
556: operating_unit_id,

Line 554: INSERT INTO CSD_RETURNS_BI_MTL_TXNS_F

550: l_run_date := sysdate - 5 / (24 * 60);
551:
552: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_MTL_TXNS_F ...');
553:
554: INSERT INTO CSD_RETURNS_BI_MTL_TXNS_F
555: (transaction_id,
556: operating_unit_id,
557: inventory_org_id,
558: inventory_item_id,

Line 724: (C_CSD_RETURNS_BI_MTL_TXNS_F,

720: program_login_id,
721: program_application_id,
722: request_id)
723: VALUES
724: (C_CSD_RETURNS_BI_MTL_TXNS_F,
725: l_run_date,
726: l_user_id,
727: sysdate,
728: sysdate,