DBA Data[Home] [Help]

APPS.MSC_TRG_AUDIT dependencies on FND_PROFILE

Line 182: and trunc(to_date(mi.key_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'MM-DD-YYYY'))) = trunc(mh.key_date_new)

178: and mi.CUSTOMER_COMPANY = mh.customer_name
179: and mi.CUSTOMER_SITE = mh.customer_site_name
180: and nvl(mi.DESIGNATOR,'-99999') = nvl(mh.designator_new,'-99999')
181: --and nvl(version_new,'-99999') = nvl(:old.version,'-99999')
182: and trunc(to_date(mi.key_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'MM-DD-YYYY'))) = trunc(mh.key_date_new)
183: and mi.bucket_type = mh.bucket_type_new
184: and mi.SYNC_INDICATOR='D'
185: and mh.item_name = :old.item_name
186: and mh.plan_id = :old.plan_id