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_RETURNS_BI_PVT dependencies on CSD_RETURNS_BI_SHP_TXNS_F

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

354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
355:
356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');
359:
360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;
361:
362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;

356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');
359:
360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;
361:
362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
363:
364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');

Line 364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');

360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;
361:
362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
363:
364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');
365:
366: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_SHP_TXNS_F');
367:
368: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 366: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_SHP_TXNS_F');

362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
363:
364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');
365:
366: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_SHP_TXNS_F');
367:
368: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
369:
370: l_run_date := sysdate - 5 / (24 * 60);

Line 372: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_SHP_TXNS_F ...');

368: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
369:
370: l_run_date := sysdate - 5 / (24 * 60);
371:
372: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_SHP_TXNS_F ...');
373:
374: INSERT INTO CSD_RETURNS_BI_SHP_TXNS_F
375: (
376: transaction_id,

Line 374: INSERT INTO CSD_RETURNS_BI_SHP_TXNS_F

370: l_run_date := sysdate - 5 / (24 * 60);
371:
372: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_SHP_TXNS_F ...');
373:
374: INSERT INTO CSD_RETURNS_BI_SHP_TXNS_F
375: (
376: transaction_id,
377: order_header_id,
378: order_line_id,

Line 476: (C_CSD_RETURNS_BI_SHP_TXNS_F,

472: program_login_id,
473: program_application_id,
474: request_id)
475: VALUES
476: (C_CSD_RETURNS_BI_SHP_TXNS_F,
477: l_run_date,
478: l_user_id,
479: sysdate,
480: sysdate,