DBA Data[Home] [Help]

APPS.FII_AP_INV_B_C dependencies on FII_SOURCE_LEDGER_GROUPS

Line 78: fii_source_ledger_groups fslg

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
80: AND fslg.usage_code =g_usage_code) fset
81: WHERE s.ledger_id = fset.ledger_id
82: AND ps.application_id = 200

Line 559: fii_source_ledger_groups fslg

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
561: AND XAH.AE_Header_ID = XAL.AE_Header_ID
562: AND XAL.AE_Header_ID = XDL.AE_Header_ID
563: AND XAL.AE_Line_Num = XDL.AE_Line_Num

Line 1506: from fii_source_ledger_groups fslg, fii_slg_assignments slga,

1502: gsob.currency_code, glcc.natural_account_id,
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