DBA Data[Home] [Help]

APPS.FII_AR_REVENUE_B_C dependencies on RA_CUST_TRX_TYPES_ALL

Line 581: ra_cust_trx_types_all ctt,

577: FROM
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,

Line 1168: ra_cust_trx_types_all ctt,

1164: AC.Fin_Cat_Type_Code x_fin_cat_type_code
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,

Line 3385: (select /*+ PARALLEL(a) */ * from ra_cust_trx_types_all a) ctt,

3381: (select /*+ PARALLEL(a) */ * from ra_customer_trx_lines_all a) ctl,
3382: (select /*+ PARALLEL(a) */ * from ra_customer_trx_all a) ct,
3383: --**bug 3437052: move sob 2 places down
3384: (select /*+ PARALLEL(a) */ * from gl_ledgers_public_v a) sob,
3385: (select /*+ PARALLEL(a) */ * from ra_cust_trx_types_all a) ctt,
3386: (select /*+ PARALLEL(a) */ * from hz_cust_accounts a) bill_acct ,
3387: (select /*+ PARALLEL(a) */ * from ra_customer_trx_lines_all a) ctl_parent,
3388: (select /*+ PARALLEL(a) */ * from oe_order_lines_all a) sl_child,
3389: (select /*+ PARALLEL(a) */ * from oe_order_headers_all a) sh,