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_REPAIR_ORDERS_F

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

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 ...');
148:
149: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_REPAIR_ORDERS_F');
150:
151: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');

Line 149: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_REPAIR_ORDERS_F');

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 ...');
148:
149: EXECUTE IMMEDIATE ('TRUNCATE TABLE CSD.CSD_REPAIR_ORDERS_F');
150:
151: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
152:
153: l_run_date := sysdate - 5 / (24 * 60);

Line 155: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_REPAIR_ORDERS_F ...');

151: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncate successful.');
152:
153: l_run_date := sysdate - 5 / (24 * 60);
154:
155: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_REPAIR_ORDERS_F ...');
156:
157: INSERT INTO CSD_REPAIR_ORDERS_F
158: (repair_line_id,
159: inventory_item_id,

Line 157: INSERT INTO CSD_REPAIR_ORDERS_F

153: l_run_date := sysdate - 5 / (24 * 60);
154:
155: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting into CSD_REPAIR_ORDERS_F ...');
156:
157: INSERT INTO CSD_REPAIR_ORDERS_F
158: (repair_line_id,
159: inventory_item_id,
160: primary_quantity,
161: primary_uom_code,

Line 214: (C_CSD_REPAIR_ORDERS_F,

210: program_login_id,
211: program_application_id,
212: request_id)
213: VALUES
214: (C_CSD_REPAIR_ORDERS_F,
215: l_run_date,
216: l_user_id,
217: sysdate,
218: sysdate,

Line 277: l_last_run_date := get_last_run_date(C_CSD_REPAIR_ORDERS_F);

273: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
274:
275: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the incremental refresh process for Repair Orders fact ...');
276:
277: l_last_run_date := get_last_run_date(C_CSD_REPAIR_ORDERS_F);
278:
279: l_run_date := sysdate - 5 / (24 * 60);
280:
281: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_REPAIR_ORDERS_F ...');

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

277: l_last_run_date := get_last_run_date(C_CSD_REPAIR_ORDERS_F);
278:
279: l_run_date := sysdate - 5 / (24 * 60);
280:
281: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_REPAIR_ORDERS_F ...');
282:
283: MERGE INTO CSD_REPAIR_ORDERS_F fact
284: USING (SELECT RO.repair_line_id,
285: RO.inventory_item_id,

Line 283: MERGE INTO CSD_REPAIR_ORDERS_F fact

279: l_run_date := sysdate - 5 / (24 * 60);
280:
281: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Merging data into CSD_REPAIR_ORDERS_F ...');
282:
283: MERGE INTO CSD_REPAIR_ORDERS_F fact
284: USING (SELECT RO.repair_line_id,
285: RO.inventory_item_id,
286: (RO.quantity * UOM.conversion_rate) primary_quantity,
287: UOM.primary_uom_code primary_uom_code,

Line 348: WHERE fact_name = C_CSD_REPAIR_ORDERS_F;

344: program_id = l_program_id,
345: program_login_id = l_program_login_id,
346: program_application_id = l_program_application_id,
347: request_id = l_request_id
348: WHERE fact_name = C_CSD_REPAIR_ORDERS_F;
349:
350: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Update complete.');
351:
352: commit;

Line 448: FROM CSD_REPAIR_ORDERS_F RO,

444: l_program_id,
445: l_program_login_id,
446: l_program_application_id,
447: l_request_id
448: FROM CSD_REPAIR_ORDERS_F RO,
449: CSD_REPAIR_JOB_XREF XREF,
450: WIP_DISCRETE_JOBS DJOB,
451: MTL_MATERIAL_TRANSACTIONS MMT,
452: MTL_SYSTEM_ITEMS_B MSI

Line 565: FROM CSD_REPAIR_ORDERS_F RO,

561: ABS(mmt.primary_quantity),
562: lc_MTL_TXN_TYPE_COMP_RETURN,
563: (-1 * ABS(mmt.primary_quantity))))) PRIMARY_QUANTITY,
564: MSI.primary_uom_code PRIMARY_UOM_CODE
565: FROM CSD_REPAIR_ORDERS_F RO,
566: CSD_REPAIR_JOB_XREF XREF,
567: WIP_DISCRETE_JOBS DJOB,
568: MTL_MATERIAL_TRANSACTIONS MMT,
569: MTL_SYSTEM_ITEMS_B MSI

Line 725: FROM CSD_REPAIR_ORDERS_F RO,

721: l_program_id,
722: l_program_login_id,
723: l_program_application_id,
724: l_request_id
725: FROM CSD_REPAIR_ORDERS_F RO,
726: CSD_REPAIR_JOB_XREF XREF,
727: WIP_DISCRETE_JOBS DJOB,
728: WIP_TRANSACTIONS WTXN
729: WHERE RO.status = 'C'

Line 830: FROM CSD_REPAIR_ORDERS_F RO,

826: USING (SELECT RO.repair_line_id,
827: WTXN.resource_id resource_id,
828: SUM(NVL(WTXN.primary_quantity, 0)) primary_quantity,
829: WTXN.primary_uom primary_uom_code
830: FROM CSD_REPAIR_ORDERS_F RO,
831: CSD_REPAIR_JOB_XREF XREF,
832: WIP_DISCRETE_JOBS DJOB,
833: WIP_TRANSACTIONS WTXN
834: WHERE RO.status = 'C'