DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 883: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;

879:
880: l_sla_hdr_event_id NUMBER;
881: l_sla_hdr_creation_date DATE;
882: l_sla_entity_id NUMBER;
883: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
884:
885: BEGIN
886: l_module_name := g_module_name || 'journal_process';
887: l_sob := g_set_of_books_id;

Line 2074: --customer_trx_line_id will be null in ra_cust_trx_line_gl_dist_all

2070: l_category = 'Debit Memos')
2071: ) THEN
2072: BEGIN
2073: --Bug 7121539
2074: --customer_trx_line_id will be null in ra_cust_trx_line_gl_dist_all
2075: --for account class 'REC', hence using customer_trx_id to get
2076: --details instead of customer_trx_line_id for these distributions
2077: SELECT account_class
2078: INTO l_account_class

Line 2079: FROM ra_cust_trx_line_gl_dist_all

2075: --for account class 'REC', hence using customer_trx_id to get
2076: --details instead of customer_trx_line_id for these distributions
2077: SELECT account_class
2078: INTO l_account_class
2079: FROM ra_cust_trx_line_gl_dist_all
2080: WHERE cust_trx_line_gl_dist_id = l_source_distribution_id_num_1;
2081:
2082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2083: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 2094: FROM ra_cust_trx_line_gl_dist_all rctgl,

2090: rcth.customer_trx_id
2091: INTO l_reference_4,
2092: l_reference_7,
2093: l_reference_2
2094: FROM ra_cust_trx_line_gl_dist_all rctgl,
2095: ra_customer_trx_lines_all rctl,
2096: ra_customer_trx_all rcth
2097: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2098: AND rctl.customer_trx_line_id = rctgl.customer_trx_line_id

Line 2107: FROM ra_cust_trx_line_gl_dist_all rctgl,

2103: rcth.customer_trx_id
2104: INTO l_reference_4,
2105: l_reference_7,
2106: l_reference_2
2107: FROM ra_cust_trx_line_gl_dist_all rctgl,
2108: ra_customer_trx_all rcth
2109: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2110: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2111: END IF;