eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_POOL_PVT dependencies on OKL_POOL_CONTENTS_UV

Line 121: -- use the following column STREAMS_FROM_DATE, STREAMS_TO_DATE for the okl_pool_contents_uv.STREAMS_FROM_DATE range search

117: ,STREAM_ELEMENT_FROM_DATE okl_strm_elements.STREAM_ELEMENT_DATE%TYPE := NULL --DATE
118: ,STREAM_ELEMENT_TO_DATE okl_strm_elements.STREAM_ELEMENT_DATE%TYPE := NULL --DATE
119: ,STREAM_ELEMENT_AMOUNT okl_strm_elements.AMOUNT%TYPE := NULL--NUMBER(14,3)
120: ,POL_ID OKL_POOL_CONTENTS.POL_ID%TYPE --NUMBER
121: -- use the following column STREAMS_FROM_DATE, STREAMS_TO_DATE for the okl_pool_contents_uv.STREAMS_FROM_DATE range search
122: ,STREAMS_FROM_DATE OKL_POOL_CONTENTS.STREAMS_FROM_DATE%TYPE := NULL --DATE
123: ,STREAMS_TO_DATE OKL_POOL_CONTENTS.STREAMS_TO_DATE%TYPE := NULL --DATE
124: ,STREAM_ELEMENT_PAYMENT_FREQ okl_time_units_v.NAME%TYPE := NULL -- VARCHAR2(80)
125: ,CUST_CRD_CLF_CODE AR_LOOKUPS.LOOKUP_CODE%TYPE := NULL --VARCHAR2(80)

Line 134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

130:
131: TYPE poc_uv_rec_type IS RECORD
132: (
133: poc_id NUMBER := OKC_API.G_MISS_NUM
134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM

Line 135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR

131: TYPE poc_uv_rec_type IS RECORD
132: (
133: poc_id NUMBER := OKC_API.G_MISS_NUM
134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR

132: (
133: poc_id NUMBER := OKC_API.G_MISS_NUM
134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR

Line 137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR

133: poc_id NUMBER := OKC_API.G_MISS_NUM
134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
141: -- mvasudev, 09/28/2004, Bug#3909240

Line 139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR

135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
141: -- mvasudev, 09/28/2004, Bug#3909240
142: ,stream_type_purpose OKL_POOL_CONTENTS_UV.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR
143: );

Line 140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR

136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
141: -- mvasudev, 09/28/2004, Bug#3909240
142: ,stream_type_purpose OKL_POOL_CONTENTS_UV.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR
143: );
144:

Line 142: ,stream_type_purpose OKL_POOL_CONTENTS_UV.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR

138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
141: -- mvasudev, 09/28/2004, Bug#3909240
142: ,stream_type_purpose OKL_POOL_CONTENTS_UV.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR
143: );
144:
145: TYPE poc_uv_tbl_type IS TABLE OF poc_uv_rec_type
146: INDEX BY BINARY_INTEGER;