DBA Data[Home] [Help]

APPS.PA_BILLING_PROCESS_PKG dependencies on PA_CUST_REV_DIST_LINES

Line 210: AND EXISTS( SELECT /*+ INDEX(crdl PA_CUST_REV_DIST_LINES_U1)*/ NULL

206: and (Rproj.revenue_accrual_method = 'WORK' or Rproj.invoice_method = 'WORK')))
207: AND ei.cost_distributed_flag = 'Y'
208: AND ei.revenue_distributed_flag = 'N'
209: AND ei.expenditure_item_date <= acc_thru_dt
210: AND EXISTS( SELECT /*+ INDEX(crdl PA_CUST_REV_DIST_LINES_U1)*/ NULL
211: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1
212: WHERE ei.project_id = crdl.project_id
213: AND (ei.expenditure_item_id = crdl.expenditure_item_id) /* 14727962 */
214: AND NVL(crdl.reversed_flag,'N') = 'N'

Line 211: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1

207: AND ei.cost_distributed_flag = 'Y'
208: AND ei.revenue_distributed_flag = 'N'
209: AND ei.expenditure_item_date <= acc_thru_dt
210: AND EXISTS( SELECT /*+ INDEX(crdl PA_CUST_REV_DIST_LINES_U1)*/ NULL
211: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1
212: WHERE ei.project_id = crdl.project_id
213: AND (ei.expenditure_item_id = crdl.expenditure_item_id) /* 14727962 */
214: AND NVL(crdl.reversed_flag,'N') = 'N'
215: AND NVL(crdl.line_num_reversed,0) = 0

Line 222: SELECT /*+ INDEX(crdl PA_CUST_REV_DIST_LINES_U1)*/ NULL

218: AND DECODE(drx1.generation_error_flag,mass_gen,decode(drx1.released_date,NULL,1,0),0)
219: = DECODE(drx1.released_date,NULL,1,0)
220: /* 14727962 */
221: UNION ALL
222: SELECT /*+ INDEX(crdl PA_CUST_REV_DIST_LINES_U1)*/ NULL
223: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1
224: WHERE ei.project_id = crdl.project_id
225: AND (ei.adjusted_expenditure_item_id IS NOT NULL
226: AND ei.adjusted_expenditure_item_id = crdl.expenditure_item_id)

Line 223: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1

219: = DECODE(drx1.released_date,NULL,1,0)
220: /* 14727962 */
221: UNION ALL
222: SELECT /*+ INDEX(crdl PA_CUST_REV_DIST_LINES_U1)*/ NULL
223: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1
224: WHERE ei.project_id = crdl.project_id
225: AND (ei.adjusted_expenditure_item_id IS NOT NULL
226: AND ei.adjusted_expenditure_item_id = crdl.expenditure_item_id)
227: AND NVL(crdl.reversed_flag,'N') = 'N'