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.PSP_ADJ_DRIVER dependencies on PSP_TEMP_ORIG_LINES

Line 385: from PSP_TEMP_ORIG_LINES

381: DECODE(g_dff_grouping_option, 'Y', attribute7, NULL) attribute7,
382: DECODE(g_dff_grouping_option, 'Y', attribute8, NULL) attribute8,
383: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
384: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
385: from PSP_TEMP_ORIG_LINES
386: where RUN_ID = g_run_id
387: group by RUN_ID,
388: SET_OF_BOOKS_ID,
389: BUSINESS_GROUP_ID,

Line 435: from PSP_TEMP_ORIG_LINES

431: DECODE(g_dff_grouping_option, 'Y', attribute7, NULL) attribute7,
432: DECODE(g_dff_grouping_option, 'Y', attribute8, NULL) attribute8,
433: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
434: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
435: from PSP_TEMP_ORIG_LINES
436: where RUN_ID = g_run_id
437: and element_group_id IS NOT NULL
438: group by RUN_ID,
439: SET_OF_BOOKS_ID,

Line 485: from PSP_TEMP_ORIG_LINES

481: DECODE(g_dff_grouping_option, 'Y', attribute7, NULL) attribute7,
482: DECODE(g_dff_grouping_option, 'Y', attribute8, NULL) attribute8,
483: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
484: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
485: from PSP_TEMP_ORIG_LINES
486: where RUN_ID = g_run_id
487: group by RUN_ID,
488: SET_OF_BOOKS_ID,
489: BUSINESS_GROUP_ID,

Line 583: insert into psp_temp_orig_lines(

579:
580: if orig_line_rec.array_distribution_line_id.count > 0 then
581: l_loop_count := l_loop_count + orig_line_rec.array_distribution_line_id.count;
582: FORALL i IN 1..orig_line_rec.array_distribution_line_id.count
583: insert into psp_temp_orig_lines(
584: element_type_id,
585: element_group_id,
586: gl_code_combination_id,
587: project_id,

Line 711: insert into psp_temp_orig_lines(

707:
708: if orig_line_rec.array_distribution_line_id.count > 0 then
709: l_loop_count := l_loop_count + orig_line_rec.array_distribution_line_id.count;
710: FORALL i IN 1..orig_line_rec.array_distribution_line_id.count
711: insert into psp_temp_orig_lines(
712: element_type_id,
713: element_group_id,
714: gl_code_combination_id,
715: project_id,

Line 839: insert into psp_temp_orig_lines(

835:
836: if orig_line_rec.array_distribution_line_id.count > 0 then
837: l_loop_count := l_loop_count + orig_line_rec.array_distribution_line_id.count;
838: FORALL i IN 1..orig_line_rec.array_distribution_line_id.count
839: insert into psp_temp_orig_lines(
840: element_type_id,
841: element_group_id,
842: gl_code_combination_id,
843: project_id,

Line 1021: Update psp_temp_orig_lines LINE

1017: orig_sumline_rec.array_attribute8(k),
1018: orig_sumline_rec.array_attribute9(k),
1019: orig_sumline_rec.array_attribute10(k));
1020:
1021: Update psp_temp_orig_lines LINE
1022: set LINE.acct_group_id = (select MAS.acct_group_id
1023: from psp_temp_orig_sumlines MAS
1024: where MAS.run_id = g_run_id and
1025: nvl(MAS.element_type_id,-9) = nvl(LINE.element_type_id,-9) and

Line 1133: Update psp_temp_orig_lines LINE

1129: orig_sumline_rec.array_attribute7(k),
1130: orig_sumline_rec.array_attribute8(k),
1131: orig_sumline_rec.array_attribute9(k),
1132: orig_sumline_rec.array_attribute10(k));
1133: Update psp_temp_orig_lines LINE
1134: set LINE.acct_group_id = (select MAS.acct_group_id
1135: from psp_temp_orig_sumlines MAS
1136: where MAS.run_id = g_run_id and
1137: nvl(MAS.element_group_id,-9) = nvl(LINE.element_group_id,-9) and

Line 1244: Update psp_temp_orig_lines LINE

1240: orig_sumline_rec.array_attribute9(k),
1241: orig_sumline_rec.array_attribute10(k));
1242:
1243:
1244: Update psp_temp_orig_lines LINE
1245: set LINE.acct_group_id = (select MAS.acct_group_id
1246: from psp_temp_orig_sumlines MAS
1247: where MAS.run_id = g_run_id and
1248: -- MAS.dr_cr_flag = LINE.dr_cr_flag and Commented for bug 3625667

Line 2853: psp_temp_orig_lines PTOS

2849: PTOS.time_period_id,
2850: Sum(decode (PTOS.dr_cr_flag, 'D', PTOS.distribution_amount,
2851: -PTOS.distribution_amount))
2852: from psp_temp_dest_sumlines PTDS,
2853: psp_temp_orig_lines PTOS
2854: where PTDS.original_line_flag = 'Y'
2855: and PTDS.acct_group_id = PTOS.acct_group_id
2856: and PTDS.run_id = g_run_id
2857: and PTOS.run_id = g_run_id

Line 3250: from psp_temp_orig_lines ptol, psp_temp_dest_sumlines ptds

3246: ptds.attribute7,
3247: ptds.attribute8,
3248: ptds.attribute9,
3249: ptds.attribute10
3250: from psp_temp_orig_lines ptol, psp_temp_dest_sumlines ptds
3251: where ptol.business_group_id = p_business_group_id
3252: and ptol.set_of_books_id = p_set_of_books_id
3253: and ptol.business_group_id = ptds.business_group_id
3254: and ptol.set_of_books_id = ptds.set_of_books_id

Line 3430: psp_temp_orig_lines LINES,

3426: dest.attribute9,
3427: dest.attribute10
3428: from psp_temp_dest_sumlines ORIG,
3429: psp_temp_dest_sumlines DEST,
3430: psp_temp_orig_lines LINES,
3431: -- Introduced the following for bug fix 3892097
3432: per_time_periods ptp,
3433: (SELECT adj_set_number,
3434: COUNT(DISTINCT DECODE(gl_code_combination_id, NULL, 'P', 'G')) transaction_type_count

Line 3949: delete from psp_temp_orig_lines where run_id = p_run_id;

3945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END IF;
3948:
3949: delete from psp_temp_orig_lines where run_id = p_run_id;
3950: delete from psp_temp_orig_sumlines where run_id = p_run_id;
3951: delete from psp_temp_dest_sumlines where run_id = p_run_id;
3952:
3953: -- 4992668

Line 4039: delete from psp_temp_orig_lines;

4035: /***** Commented the following DELETE statements for the following reasons as part of R12 performance fixes (bug 4507892)
4036: 1) These DELETE statements donot have proper COMMIT logic.
4037: 2) Doesnt check for proper run_id.
4038: 3) Non-performant SQLs.
4039: delete from psp_temp_orig_lines;
4040: delete from psp_temp_orig_sumlines;
4041: delete from psp_temp_dest_sumlines;
4042: End of comment for bug fix 4507892 *****/
4043: g_error_api_path := 'GENERATE_LINES:'||g_error_api_path||sqlerrm;

Line 4463: FROM psp_temp_orig_lines ptol

4459: r_eff_date_record eff_date_rec_type;
4460:
4461: CURSOR c_orig_values IS
4462: SELECT MAX(ptol.effective_date)
4463: FROM psp_temp_orig_lines ptol
4464: WHERE ptol.acct_group_id = p_acct_group_id
4465: AND ptol.run_id = p_run_id
4466: GROUP BY payroll_control_id,
4467: dr_cr_flag;