DBA Data[Home] [Help]

APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on FII_GL_CCID_DIMENSIONS

Line 366: fii_gl_ccid_dimensions glcc,

362: ap_invoices_all ai,
363: ap_invoice_lines_all ail,
364: ap_invoice_distributions_all aid,
365: gl_ledgers_public_v gsob,
366: fii_gl_ccid_dimensions glcc,
367: fnd_user fnd,
368: fii_slg_assignments slga,
369: fii_source_ledger_groups fslg
370: WHERE ai.invoice_id = temp.invoice_id

Line 1215: gl_ledgers_public_v gsob, fii_gl_ccid_dimensions glcc

1211: glcc.company_id, glcc.cost_center_id,
1212: gsob.chart_of_accounts_id, glcc.user_dim1_id,
1213: glcc.user_dim2_id
1214: from fii_source_ledger_groups fslg, fii_slg_assignments slga,
1215: gl_ledgers_public_v gsob, fii_gl_ccid_dimensions glcc
1216: where slga.chart_of_accounts_id = glcc.chart_of_accounts_id
1217: and slga.bal_seg_value_id in (glcc.company_id, -1)
1218: and slga.source_ledger_group_id = fslg.source_ledger_group_id
1219: and slga.ledger_id = gsob.ledger_id