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_RCV_TXNS_F

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

140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
141:
142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');
143:
144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');
145:
146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;
147:
148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;

142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');
143:
144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');
145:
146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;
147:
148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
149:
150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');

Line 150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');

146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;
147:
148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
149:
150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');
151:
152: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_RCV_TXNS_F');
153:
154: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 152: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_RCV_TXNS_F');

148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
149:
150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');
151:
152: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_RETURNS_BI_RCV_TXNS_F');
153:
154: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
155:
156: l_run_date := sysdate - 5 / (24 * 60);

Line 158: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_RCV_TXNS_F ...');

154: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
155:
156: l_run_date := sysdate - 5 / (24 * 60);
157:
158: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_RCV_TXNS_F ...');
159:
160: INSERT INTO CSD_RETURNS_BI_RCV_TXNS_F
161: (
162: transaction_id,

Line 160: INSERT INTO CSD_RETURNS_BI_RCV_TXNS_F

156: l_run_date := sysdate - 5 / (24 * 60);
157:
158: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_RETURNS_BI_RCV_TXNS_F ...');
159:
160: INSERT INTO CSD_RETURNS_BI_RCV_TXNS_F
161: (
162: transaction_id,
163: order_header_id,
164: order_line_id,

Line 295: (C_CSD_RETURNS_BI_RCV_TXNS_F,

291: program_login_id,
292: program_application_id,
293: request_id)
294: VALUES
295: (C_CSD_RETURNS_BI_RCV_TXNS_F,
296: l_run_date,
297: l_user_id,
298: sysdate,
299: sysdate,