APPS.PA_INVOICE_TIEBACK dependencies on RA_CUSTOMER_TRX_LINES

Line 32: ra_customer_trx_lines trx

28: /* Commented the code change done for bug 4022244 and modified the previous
29: query as below for this bug 6443623 */
30: Select sum(tgl.acctd_amount)
31: from ra_cust_trx_line_gl_dist_all tgl,
32: ra_customer_trx_lines trx
33: where trx.customer_trx_id = l_cust_trx_id
34: and trim(trx.interface_line_attribute6)
35: = to_char(l_line_num)
36: and rtrim(ltrim(trx.interface_line_attribute1)) = l_project_num

Line 44: ra_customer_trx_lines trx_lines,

40: /* Bug 4022244. Modified the cursor query to add a new join for interface_line_context */
41: /* Commenting the code for Bug 6443623
42: Select sum(tgl.acctd_amount)
43: from ra_cust_trx_line_gl_dist_all tgl,
44: ra_customer_trx_lines trx_lines,
45: ra_customer_trx trx, ra_batch_sources source
46: where trx_lines.customer_trx_id = trx.customer_trx_id
47: and trx.batch_source_id = source.batch_source_id
48: and trx_lines.interface_line_context = source.name

Line 59: ra_customer_trx_lines trx

55: */
56: /* Commenting the following for bug 4022244.
57: Select sum(tgl.acctd_amount)
58: from ra_cust_trx_line_gl_dist_all tgl,
59: ra_customer_trx_lines trx
60: where trx.customer_trx_id = l_cust_trx_id
61: and to_number(trunc(trx.interface_line_attribute6))
62: = l_line_num
63: and rtrim(ltrim(trx.interface_line_attribute1)) = l_project_num