DBA Data[Home] [Help]

APPS.OKS_REV_DISTR_PUB dependencies on MTL_PARAMETERS

Line 605: -- ,MTL_PARAMETERS MP

601: --Cursor modified as part of bug# 3599223
602: -- CURSOR CUR_CHART_ACC Is
603: -- SELECT HOU.ORGANIZATION_ID
604: -- FROM hr_organization_units HOU
605: -- ,MTL_PARAMETERS MP
606: -- ,FND_PRODUCT_GROUPS
607: -- WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
608: -- AND EXISTS ( SELECT 1
609: -- FROM HR_ORGANIZATION_INFORMATION HOI1

Line 627: ,MTL_PARAMETERS MP

623: --Merge cartesian join
624: CURSOR CUR_CHART_ACC Is
625: SELECT GSOB.CHART_OF_ACCOUNTS_ID
626: FROM HR_ORGANIZATION_UNITS HOU
627: ,MTL_PARAMETERS MP
628: --,FND_PRODUCT_GROUPS
629: ,GL_SETS_OF_BOOKS GSOB
630: ,HR_ORGANIZATION_INFORMATION HOI2
631: WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID