DBA Data[Home] [Help]

APPS.INVTVTUS dependencies on GL_SETS_OF_BOOKS

Line 28: gl_sets_of_books sob,

24: /*Bug4950410 : Added the following query to get the currency precision to round the inventory value.
25: Also rounding the net_val and abs_val based on the currency precision of the organization. */
26: select fc.precision into prc
27: from org_organization_definitions ood,
28: gl_sets_of_books sob,
29: fnd_currencies fc
30: where ood.organization_id = orgid
31: and ood.set_of_books_id = sob.set_of_books_id
32: and fc.currency_code = sob.currency_code;

Line 395: gl_sets_of_books sob,

391: Also rounding the net_val and abs_val based on the currency precision of the organization. */
392:
393: select fc.precision into prc
394: from org_organization_definitions ood,
395: gl_sets_of_books sob,
396: fnd_currencies fc
397: where ood.organization_id = orgid
398: and ood.set_of_books_id = sob.set_of_books_id
399: and fc.currency_code = sob.currency_code;

Line 817: gl_sets_of_books sob,

813: /*Bug4950410 : Added the following query to get the currency precision to round the inventory value.
814: Also rounding the net_val and abs_val based on the currency precision of the organization. */
815: select fc.precision into prc
816: from org_organization_definitions ood,
817: gl_sets_of_books sob,
818: fnd_currencies fc
819: where ood.organization_id = orgid
820: and ood.set_of_books_id = sob.set_of_books_id
821: and fc.currency_code = sob.currency_code;