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.PA_BILLING_AMOUNT dependencies on PA_TASKS

Line 74: AND EXISTS (select 1 from pa_tasks t

70: from pa_periods pp
71: where nvl(X2_accrue_through_date,sysdate) >= trunc(pp.start_date) --Removed to_date
72: and pp.period_name = ta.pa_period
73: )
74: AND EXISTS (select 1 from pa_tasks t
75: where t.task_id = ta.task_id
76: and exists (select 1 from pa_tasks t1
77: where t1.task_id = t.top_task_id
78: and decode(l_calling_process,'Revenue',t1.ready_to_distribute_flag,

Line 76: and exists (select 1 from pa_tasks t1

72: and pp.period_name = ta.pa_period
73: )
74: AND EXISTS (select 1 from pa_tasks t
75: where t.task_id = ta.task_id
76: and exists (select 1 from pa_tasks t1
77: where t1.task_id = t.top_task_id
78: and decode(l_calling_process,'Revenue',t1.ready_to_distribute_flag,
79: 'Invoice',t1.ready_to_bill_flag,0) = 'Y')
80: ) /* Exists clause added for bug 7299493 */

Line 95: AND EXISTS (select 1 from pa_tasks t

91: from pa_periods pp
92: where nvl(X2_accrue_through_date,sysdate) >= trunc(pp.start_date) --Removed to_date
93: and cdl.pa_date between pp.start_date and pp.end_date
94: )
95: AND EXISTS (select 1 from pa_tasks t
96: where t.task_id = cdl.task_id
97: and exists (select 1 from pa_tasks t1
98: where t1.task_id = t.top_task_id
99: and decode(l_calling_process,'Revenue',t1.ready_to_distribute_flag,

Line 97: and exists (select 1 from pa_tasks t1

93: and cdl.pa_date between pp.start_date and pp.end_date
94: )
95: AND EXISTS (select 1 from pa_tasks t
96: where t.task_id = cdl.task_id
97: and exists (select 1 from pa_tasks t1
98: where t1.task_id = t.top_task_id
99: and decode(l_calling_process,'Revenue',t1.ready_to_distribute_flag,
100: 'Invoice',t1.ready_to_bill_flag,0) = 'Y')
101: ) /* Exists clause added for bug 7299493 */

Line 114: pa_tasks t

110: SELECT sum(nvl(ta.tot_burdened_cost, nvl(ta.tot_raw_cost,0)) +
111: nvl(ta.i_tot_burdened_cost, nvl(i_tot_raw_cost,0))) BURDENED_COST
112: FROM
113: pa_txn_accum ta,
114: pa_tasks t
115: WHERE ta.task_id = t.task_id
116: AND t.top_task_id = X2_task_id
117: AND t.project_id = X2_project_id
118: AND ta.project_id = X2_project_id

Line 120: and exists (select 1 from pa_tasks t1

116: AND t.top_task_id = X2_task_id
117: AND t.project_id = X2_project_id
118: AND ta.project_id = X2_project_id
119: AND ta.project_id = t.project_id
120: and exists (select 1 from pa_tasks t1
121: where t1.task_id = t.top_task_id
122: and decode(l_calling_process,'Revenue',t1.ready_to_distribute_flag,
123: 'Invoice',t1.ready_to_bill_flag,0) = 'Y') /* Exists clause added for bug 7299493 */
124:

Line 135: /pa_tasks commented for bug 6521198/

131: )
132: UNION ALL
133: SELECT sum(nvl((cdl.burdened_cost + nvl(project_burdened_change,0)), nvl(cdl.amount,0))) BURDENED_COST
134: FROM pa_cost_distribution_lines_all cdl /* Added _all for bug 5953670*/
135: /*pa_tasks commented for bug 6521198*/
136: WHERE EXISTS ( select 1 from pa_tasks t
137: WHERE cdl.project_id = t.project_id
138: AND cdl.task_id = t.task_id
139: AND t.project_id = X2_project_id

Line 136: WHERE EXISTS ( select 1 from pa_tasks t

132: UNION ALL
133: SELECT sum(nvl((cdl.burdened_cost + nvl(project_burdened_change,0)), nvl(cdl.amount,0))) BURDENED_COST
134: FROM pa_cost_distribution_lines_all cdl /* Added _all for bug 5953670*/
135: /*pa_tasks commented for bug 6521198*/
136: WHERE EXISTS ( select 1 from pa_tasks t
137: WHERE cdl.project_id = t.project_id
138: AND cdl.task_id = t.task_id
139: AND t.project_id = X2_project_id
140: AND t.top_task_id = X2_task_id

Line 141: and exists (select 1 from pa_tasks t1

137: WHERE cdl.project_id = t.project_id
138: AND cdl.task_id = t.task_id
139: AND t.project_id = X2_project_id
140: AND t.top_task_id = X2_task_id
141: and exists (select 1 from pa_tasks t1
142: where t1.task_id = t.top_task_id
143: and decode(l_calling_process,'Revenue',t1.ready_to_distribute_flag,
144: 'Invoice',t1.ready_to_bill_flag,0) = 'Y') /* Exists clause added for bug 7294641 */
145: )

Line 737: pa_tasks t

733: SELECT sum(nvl(rdl.projfunc_bill_amount,0))
734: INTO task_billed_ccinv
735: FROM pa_cust_rev_dist_lines rdl,
736: pa_expenditure_items_all ei,
737: pa_tasks t
738: WHERE ei.task_id = t.task_id
739: AND ei.expenditure_item_id = rdl.expenditure_item_id
740: AND rdl.project_id = X2_project_id
741: AND t.top_task_id = X2_task_id