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 2192: gl_sets_of_books sob

2188: FROM ra_ar_gt
2189: WHERE source_table = 'CTLGD'
2190: GROUP BY ref_customer_trx_id,
2191: to_currency) trx,
2192: gl_sets_of_books sob
2193: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
2194: AND adj.type = 'INVOICE'
2195: AND adj.status = 'A'
2196: AND adj.postable = 'Y'

Line 2407: gl_sets_of_books sob

2403: MAX(to_currency) invoice_currency_code
2404: FROM ra_ar_gt
2405: WHERE gt_id = p_gt_id
2406: GROUP BY ref_customer_trx_id, to_currency) trx,
2407: gl_sets_of_books sob
2408: WHERE adj.customer_trx_id = p_trx_id
2409: AND adj.customer_trx_id = trx.ref_customer_trx_id
2410: AND adj.type = 'INVOICE'
2411: AND adj.status = 'A'