DBA Data[Home] [Help]

APPS.OPI_DBI_COGS_PKG dependencies on GL_SETS_OF_BOOKS

Line 1495: gl_sets_of_books gsob

1491: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
1492: parallel (hoi) parallel (gsob)*/
1493: DISTINCT hoi.organization_id, gsob.currency_code
1494: FROM hr_organization_information hoi,
1495: gl_sets_of_books gsob
1496: WHERE hoi.org_information_context = 'Accounting Information'
1497: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1498: curr_codes
1499: WHERE curr_codes.organization_id = to_conv.organization_id;

Line 1750: gl_sets_of_books gsob

1746: FROM opi_dbi_cogs_fstg) to_conv,
1747: (SELECT
1748: DISTINCT hoi.organization_id, gsob.currency_code
1749: FROM hr_organization_information hoi,
1750: gl_sets_of_books gsob
1751: WHERE hoi.org_information_context = 'Accounting Information'
1752: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1753: curr_codes
1754: WHERE curr_codes.organization_id = to_conv.organization_id;