DBA Data[Home] [Help]

APPS.OKE_CHANGE_STATUS_PUB dependencies on FND_LOOKUPS

Line 162: ,fnd_lookups ST

158: S.CODE STATUS_CODE
159: ,S.STE_CODE STE_CODE
160: from
161: okc_statuses_v S
162: ,fnd_lookups ST
163: where
164: S.STE_CODE in
165: (
166: NVL(p_old_ste_code,'ENTERED')

Line 193: ,FND_LOOKUPS ST

189: UNION ALL
190: SELECT S.CODE STATUS_CODE
191: ,S.STE_CODE STE_CODE1
192: FROM OKC_STATUSES_V S
193: ,FND_LOOKUPS ST
194: WHERE S.STE_CODE in ('ENTERED', 'CANCELLED')
195: AND SYSDATE BETWEEN S.START_DATE AND NVL(S.END_DATE, SYSDATE)
196: AND ST.LOOKUP_TYPE = 'OKC_STATUS_TYPE'
197: AND ST.LOOKUP_CODE=S.STE_CODE