APPS.FII_AR_REVENUE_B_C dependencies on GL_LEDGERS_PUBLIC_V

Line 65: gl_ledgers_public_v s,

61: SELECT DISTINCT
62: s.ledger_id,
63: s.name
64: FROM gl_period_statuses ps,
65: gl_ledgers_public_v s,
66: fa_deprn_periods dp,
67: fa_book_controls bc,
68: (SELECT DISTINCT slga.ledger_id
69: FROM fii_slg_assignments slga,

Line 88: gl_ledgers_public_v s,

84: SELECT DISTINCT
85: s.ledger_id,
86: s.name
87: FROM gl_period_statuses ps,
88: gl_ledgers_public_v s,
89: (SELECT DISTINCT slga.ledger_id
90: FROM fii_slg_assignments slga,
91: fii_source_ledger_groups fslg
92: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 106: gl_ledgers_public_v s,

102: SELECT DISTINCT
103: s.ledger_id,
104: s.name
105: FROM gl_period_statuses ps,
106: gl_ledgers_public_v s,
107: (SELECT DISTINCT slga.ledger_id
108: FROM fii_slg_assignments slga,
109: fii_source_ledger_groups fslg
110: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 589: gl_ledgers_public_v sob,

585: fii_slg_assignments slga,
586: fii_source_ledger_groups fslg,
587: -- fii_fin_cat_type_assgns ffcta,
588: ra_customer_trx_lines_all ctl_parent,
589: gl_ledgers_public_v sob,
590: hz_cust_accounts bill_acct,
591: oe_order_lines_all sl_child,
592: oe_order_lines_all sl_parent,
593: oe_order_headers_all sh,

Line 869: gl_ledgers_public_v sob,

865: -- ra_customer_trx_lines_all ctl_parent,
866: -- oe_order_lines_all sl_child,
867: -- oe_order_headers_all sh,
868: -- oe_order_lines_all sl_parent,
869: gl_ledgers_public_v sob,
870: hz_cust_accounts bill_acct,
871: ACCNT_CLASS AC,
872: xla_ae_headers aeh,
873: xla_ae_lines ael,

Line 1219: gl_ledgers_public_v sob,

1215: ctl.interface_line_context,
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,

Line 3384: (select /*+ PARALLEL(a) */ * from gl_ledgers_public_v a) sob,

3380: ) v1,
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,