DBA Data[Home] [Help]

APPS.FII_AR_REVENUE_B_C dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 582: ra_cust_trx_line_gl_dist_all ctlgd,

578: fii_ar_revenue_id fpk,
579: ra_customer_trx_lines_all ctl,
580: ra_customer_trx_all ct,
581: ra_cust_trx_types_all ctt,
582: ra_cust_trx_line_gl_dist_all ctlgd,
583: gl_code_combinations glcc,
584: fii_gl_ccid_dimensions ccdim,
585: fii_slg_assignments slga,
586: fii_source_ledger_groups fslg,

Line 609: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

605: AND aeh.ae_header_id = ael.ae_header_id
606: AND lnk.application_id = 222
607: AND ael.ae_header_id = lnk.ae_header_id
608: AND ael.ae_line_num = lnk.ae_line_num
609: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
610: AND lnk.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
611: AND aeh.ledger_id = ctlgd.set_of_books_id
612: AND nvl(ctl.interface_line_context, 'xxx') <> 'PA INVOICES'
613: AND ct.customer_trx_id = ctl.customer_trx_id

Line 1169: ra_cust_trx_line_gl_dist_all ctlgd,

1165: from fii_ar_revenue_id fpk,
1166: ra_customer_trx_lines_all ctl,
1167: ra_customer_trx_all ct,
1168: ra_cust_trx_types_all ctt,
1169: ra_cust_trx_line_gl_dist_all ctlgd,
1170: ACCNT_CLASS AC,
1171: xla_distribution_links lnk,
1172: xla_ae_lines ael,
1173: xla_ae_headers aeh

Line 1196: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1192: AND aeh.ae_header_id = ael.ae_header_id
1193: AND lnk.application_id = 222
1194: AND ael.ae_header_id = lnk.ae_header_id
1195: AND ael.ae_line_num = lnk.ae_line_num
1196: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1197: AND lnk.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
1198: AND aeh.ledger_id = ctlgd.set_of_books_id
1199: AND ael.accounting_class_code = AC.Accounting_Class_Code
1200: AND ( aeh.ledger_id = AC.Ledger_ID OR AC.Ledger_ID IS NULL )

Line 1899: -- For ra_cust_trx_line_gl_dist_all

1895: */
1896:
1897: ELSIF (p_type = 'AR DL') THEN
1898: -- -----------------------------------------
1899: -- For ra_cust_trx_line_gl_dist_all
1900: -- -----------------------------------------
1901:
1902: ---------------------------------------------
1903: -- For 'AR DL', if identifying future dated

Line 3346: FROM ra_cust_trx_line_gl_dist_all ctlgd,

3342: NULL,
3343: ael.code_combination_id,
3344: 'Y' POSTED_FLAG,
3345: AC.Fin_Cat_Type_Code
3346: FROM ra_cust_trx_line_gl_dist_all ctlgd,
3347: (
3348: select /*+ no_merge use_hash(slga,fslg) */ distinct ledger_id
3349: from fii_slg_assignments slga, fii_source_ledger_groups fslg
3350: where slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 3371: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

3367: AND aeh.ae_header_id = ael.ae_header_id
3368: AND lnk.application_id = 222
3369: AND ael.ae_header_id = lnk.ae_header_id
3370: AND ael.ae_line_num = lnk.ae_line_num
3371: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
3372: AND lnk.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
3373: AND aeh.ledger_id = ctlgd.set_of_books_id
3374: AND ael.accounting_class_code = AC.Accounting_Class_Code
3375: AND ( aeh.ledger_id = AC.Ledger_ID OR AC.Ledger_ID IS NULL )