DBA Data[Home] [Help]

APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on GL_SETS_OF_BOOKS

Line 101: gl_sets_of_books sob,

97: g_ae_sys_rec.loss_cc_id,
98: g_ae_sys_rec.round_cc_id,
99: x_accounting_method
100: FROM ar_system_parameters_all sysp,
101: gl_sets_of_books sob,
102: fnd_currencies c
103: WHERE sysp.org_id = p_org_id
104: AND sob.set_of_books_id = sysp.set_of_books_id --would be the row returned from multi org view
105: AND sob.currency_code = c.currency_code;

Line 1994: gl_sets_of_books sob

1990: FROM ra_ar_gt
1991: WHERE source_table = 'CTLGD'
1992: GROUP BY ref_customer_trx_id,
1993: to_currency) trx,
1994: gl_sets_of_books sob
1995: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
1996: AND adj.type = 'INVOICE'
1997: AND adj.status = 'A'
1998: AND adj.postable = 'Y'

Line 2208: gl_sets_of_books sob

2204: MAX(to_currency) invoice_currency_code
2205: FROM ra_ar_gt
2206: WHERE gt_id = p_gt_id
2207: GROUP BY ref_customer_trx_id, to_currency) trx,
2208: gl_sets_of_books sob
2209: WHERE adj.customer_trx_id = p_trx_id
2210: AND adj.customer_trx_id = trx.ref_customer_trx_id
2211: AND adj.type = 'INVOICE'
2212: AND adj.status = 'A'