APPS.FII_AP_INV_B_C dependencies on GL_LEDGERS_PUBLIC_V

Line 75: gl_ledgers_public_v s,

71: SELECT DISTINCT
72: s.ledger_id,
73: s.name
74: FROM gl_period_statuses ps,
75: gl_ledgers_public_v s,
76: (SELECT DISTINCT slga.ledger_id
77: FROM fii_slg_assignments slga,
78: fii_source_ledger_groups fslg
79: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 556: gl_ledgers_public_v gsob,

552: where accounting_date >= g_start_date
553: group by vouchno) rh,
554: po_distributions_all pd,
555: po_headers_all ph,
556: gl_ledgers_public_v gsob,
557: fii_gl_ccid_dimensions glcc,
558: fii_slg_assignments slga,
559: fii_source_ledger_groups fslg
560: WHERE XAH.Entity_ID = XTE.Entity_ID

Line 1507: gl_ledgers_public_v gsob, fii_gl_ccid_dimensions glcc

1503: glcc.company_id, glcc.cost_center_id,
1504: gsob.chart_of_accounts_id, glcc.user_dim1_id,
1505: glcc.user_dim2_id
1506: from fii_source_ledger_groups fslg, fii_slg_assignments slga,
1507: gl_ledgers_public_v gsob, fii_gl_ccid_dimensions glcc
1508: where slga.chart_of_accounts_id = glcc.chart_of_accounts_id
1509: and slga.bal_seg_value_id in (glcc.company_id, -1)
1510: and slga.source_ledger_group_id = fslg.source_ledger_group_id
1511: and slga.ledger_id = gsob.ledger_id