53: GL_SETS_OF_BOOKS SOB,
54: FND_CURRENCIES FC,
55: MTL_CATEGORY_SETS MCS,
56: MFG_LOOKUPS LOOKUP1,
57: MTL_TXN_SOURCE_TYPES STYPE1,
58: MTL_TXN_SOURCE_TYPES STYPE2,
59: MTL_TXN_SOURCE_TYPES STYPE3,
60: MTL_TXN_SOURCE_TYPES STYPE4
61: WHERE OOD.ORGANIZATION_ID = P_ORG_ID
54: FND_CURRENCIES FC,
55: MTL_CATEGORY_SETS MCS,
56: MFG_LOOKUPS LOOKUP1,
57: MTL_TXN_SOURCE_TYPES STYPE1,
58: MTL_TXN_SOURCE_TYPES STYPE2,
59: MTL_TXN_SOURCE_TYPES STYPE3,
60: MTL_TXN_SOURCE_TYPES STYPE4
61: WHERE OOD.ORGANIZATION_ID = P_ORG_ID
62: AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
55: MTL_CATEGORY_SETS MCS,
56: MFG_LOOKUPS LOOKUP1,
57: MTL_TXN_SOURCE_TYPES STYPE1,
58: MTL_TXN_SOURCE_TYPES STYPE2,
59: MTL_TXN_SOURCE_TYPES STYPE3,
60: MTL_TXN_SOURCE_TYPES STYPE4
61: WHERE OOD.ORGANIZATION_ID = P_ORG_ID
62: AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
63: AND FC.CURRENCY_CODE = SOB.CURRENCY_CODE
56: MFG_LOOKUPS LOOKUP1,
57: MTL_TXN_SOURCE_TYPES STYPE1,
58: MTL_TXN_SOURCE_TYPES STYPE2,
59: MTL_TXN_SOURCE_TYPES STYPE3,
60: MTL_TXN_SOURCE_TYPES STYPE4
61: WHERE OOD.ORGANIZATION_ID = P_ORG_ID
62: AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
63: AND FC.CURRENCY_CODE = SOB.CURRENCY_CODE
64: AND MCS.CATEGORY_SET_ID = P_CAT_SET_ID