DBA Data[Home] [Help]

APPS.OKE_CHANGE_STATUS_PUB dependencies on OKC_STATUSES_V

Line 161: okc_statuses_v S

157: (select
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: (

Line 192: FROM OKC_STATUSES_V S

188: AND p_old_ste_code <> 'CANCELLED'
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'