DBA Data[Home] [Help]

APPS.FII_AR_REVENUE_B_C dependencies on GL_CODE_COMBINATIONS

Line 583: gl_code_combinations glcc,

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,
587: -- fii_fin_cat_type_assgns ffcta,

Line 858: gl_code_combinations gcc,

854: FROM
855: fii_ar_revenue_id fpk,
856: ar_adjustments_all adj,
857: ar_distributions_all ad,
858: gl_code_combinations gcc,
859: fii_gl_ccid_dimensions ccdim,
860: fii_slg_assignments slga,
861: fii_source_ledger_groups fslg,
862: -- fii_fin_cat_type_assgns ffcta,

Line 1220: gl_code_combinations glcc,

1216: ctl.interface_line_attribute6,
1217: AC.Fin_Cat_Type_Code
1218: ) X,
1219: gl_ledgers_public_v sob,
1220: gl_code_combinations glcc,
1221: ra_customer_trx_lines_all ctl_parent,
1222: hz_cust_accounts bill_acct,
1223: oe_order_lines_all sl_child,
1224: oe_order_lines_all sl_parent,

Line 3270: (select /*+ PARALLEL(a) */ * from gl_code_combinations a) gcc,

3266: FROM (select /*+ PARALLEL(a) */ * from fii_source_ledger_groups a) fslg,
3267: (select /*+ PARALLEL(a) */ * from fii_slg_assignments a) slga,
3268: (select /*+ PARALLEL(a) */ * from fii_gl_ccid_dimensions a) ccdim,
3269: -- (select /*+ PARALLEL(a) */ * from fii_fin_cat_type_assgns a) ffcta,
3270: (select /*+ PARALLEL(a) */ * from gl_code_combinations a) gcc,
3271: (
3272: SELECT /*+ PARALLEL(adj) PARALLEL(ad) parallel(lidset)
3273: PARALLEL(AC) PARALLEL(lnk) PARALLEL(ael) PARALLEL(aeh) */
3274: ad.line_id REVENUE_PK,