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_ITEM_RESIDUALS_PVT dependencies on OKL_FE_ITEM_RESIDUAL

Line 136: OKL_FE_ITEM_RESIDUAL IRHV

132: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
133: WHERE rate_card_id IN(SELECT
134: LRFVERV.RATE_SET_ID LRS_ID
135: FROM
136: OKL_FE_ITEM_RESIDUAL IRHV
137: , OKL_ITM_CAT_RV_PRCS_V ICPV
138: , OKL_FE_EO_TERM_OBJECTS EOTL
139: , OKL_FE_EO_TERM_VERS_V EOTVERV
140: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 158: OKL_FE_ITEM_RESIDUAL IRHV

154: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
155: WHERE rate_card_id IN(SELECT
156: LRFVERV.RATE_SET_ID LRS_ID
157: FROM
158: OKL_FE_ITEM_RESIDUAL IRHV
159: , OKL_ITM_CAT_RV_PRCS_V ICPV
160: , OKL_FE_EO_TERM_OBJECTS EOTL
161: , OKL_FE_EO_TERM_VERS_V EOTVERV
162: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 179: OKL_FE_ITEM_RESIDUAL IRHV

175: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
176: WHERE rate_card_id IN(SELECT
177: LRFVERV.RATE_SET_ID LRS_ID
178: FROM
179: OKL_FE_ITEM_RESIDUAL IRHV
180: , OKL_ITM_CAT_RV_PRCS_V ICPV
181: , OKL_FE_EO_TERM_OBJECTS EOTL
182: , OKL_FE_EO_TERM_VERS_V EOTVERV
183: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 199: OKL_FE_ITEM_RESIDUAL IRHV

195: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
196: WHERE rate_card_id IN (SELECT
197: LRFVERV.RATE_SET_ID LRS_ID
198: FROM
199: OKL_FE_ITEM_RESIDUAL IRHV
200: , OKL_ITM_CAT_RV_PRCS_V ICPV
201: , OKL_FE_EO_TERM_OBJECTS EOTL
202: , OKL_FE_EO_TERM_VERS_V EOTVERV
203: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 221: OKL_FE_ITEM_RESIDUAL IRHV

217: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
218: WHERE rate_card_id IN (SELECT
219: LRFVERV.RATE_SET_ID LRS_ID
220: FROM
221: OKL_FE_ITEM_RESIDUAL IRHV
222: , OKL_ITM_CAT_RV_PRCS_V ICPV
223: , OKL_FE_EO_TERM_OBJECTS EOTL
224: , OKL_FE_EO_TERM_VERS_V EOTVERV
225: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 242: OKL_FE_ITEM_RESIDUAL IRHV

238: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
239: WHERE rate_card_id IN (SELECT
240: LRFVERV.RATE_SET_ID LRS_ID
241: FROM
242: OKL_FE_ITEM_RESIDUAL IRHV
243: , OKL_ITM_CAT_RV_PRCS_V ICPV
244: , OKL_FE_EO_TERM_OBJECTS EOTL
245: , OKL_FE_EO_TERM_VERS_V EOTVERV
246: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 266: , OKL_FE_ITEM_RESIDUAL IRHV

262: , ICPV.ITEM_RESIDUAL_ID
263: , IRHV.CATEGORY_TYPE_CODE
264: FROM
265: OKL_ITM_CAT_RV_PRCS_V ICPV
266: , OKL_FE_ITEM_RESIDUAL IRHV
267: WHERE
268: IRHV.ITEM_RESIDUAL_ID = ICPV.ITEM_RESIDUAL_ID
269: AND ICPV.ID = p_ver_id;
270:

Line 999: OKL_FE_ITEM_RESIDUAL IRHV

995: LRFVERV.RATE_SET_VERSION_ID LRS_VERSION_ID
996: , LRFV.NAME LRS_NAME
997: , LRFVERV.VERSION_NUMBER LRS_VERSION_NUMBER
998: FROM
999: OKL_FE_ITEM_RESIDUAL IRHV
1000: , OKL_ITM_CAT_RV_PRCS_V ICPV
1001: , OKL_FE_EO_TERM_OBJECTS EOTL
1002: , OKL_FE_EO_TERM_VERS_V EOTVERV
1003: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 1028: OKL_FE_ITEM_RESIDUAL IRHV

1024: LRFVERV.RATE_SET_VERSION_ID LRS_VERSION_ID
1025: , LRFV.NAME LRS_NAME
1026: , LRFVERV.VERSION_NUMBER LRS_VERSION_NUMBER
1027: FROM
1028: OKL_FE_ITEM_RESIDUAL IRHV
1029: , OKL_ITM_CAT_RV_PRCS_V ICPV
1030: , OKL_FE_EO_TERM_OBJECTS EOTL
1031: , OKL_FE_EO_TERM_VERS_V EOTVERV
1032: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 1056: OKL_FE_ITEM_RESIDUAL IRHV

1052: LRFVERV.RATE_SET_VERSION_ID LRS_VERSION_ID
1053: , LRFV.NAME LRS_NAME
1054: , LRFVERV.VERSION_NUMBER LRS_VERSION_NUMBER
1055: FROM
1056: OKL_FE_ITEM_RESIDUAL IRHV
1057: , OKL_ITM_CAT_RV_PRCS_V ICPV
1058: , OKL_FE_EO_TERM_OBJECTS EOTL
1059: , OKL_FE_EO_TERM_VERS_V EOTVERV
1060: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV

Line 1081: OKL_FE_ITEM_RESIDUAL

1077: CURSOR get_category_type(p_item_residual_id NUMBER)IS
1078: SELECT
1079: CATEGORY_TYPE_CODE
1080: FROM
1081: OKL_FE_ITEM_RESIDUAL
1082: WHERE
1083: ITEM_RESIDUAL_ID = p_item_residual_id; -- Item residual ID
1084:
1085: -- Cursor to identify change in version effective To date

Line 1318: , OKL_FE_ITEM_RESIDUAL IRHV

1314: , ICPV.VERSION_NUMBER
1315: , IRHV.OBJECT_VERSION_NUMBER HDR_OBJECT_VERSION_NUMBER
1316: FROM
1317: OKL_ITM_CAT_RV_PRCS ICPV
1318: , OKL_FE_ITEM_RESIDUAL IRHV
1319: WHERE
1320: IRHV.ITEM_RESIDUAL_ID = ICPV.ITEM_RESIDUAL_ID
1321: AND ICPV.ID = var_version_id;
1322:

Line 1558: OKL_FE_ITEM_RESIDUAL IRESDV

1554: CURSOR get_source_type(p_itm_rsdl_id NUMBER) IS
1555: SELECT
1556: IRESDV.CATEGORY_TYPE_CODE
1557: FROM
1558: OKL_FE_ITEM_RESIDUAL IRESDV
1559: WHERE
1560: IRESDV.item_residual_id = p_itm_rsdl_id;
1561:
1562: -- Cursor to check if the residual category sets are active before Activating the Item Residual

Line 1570: , OKL_FE_ITEM_RESIDUAL IRESDV

1566: RCSV.RESI_CATEGORY_SET_ID ID
1567: , RCSV.RESI_CAT_NAME NAME
1568: FROM
1569: OKL_FE_RESI_CAT_V RCSV
1570: , OKL_FE_ITEM_RESIDUAL IRESDV
1571: WHERE
1572: IRESDV.CATEGORY_TYPE_CODE = G_CAT_RES_CAT
1573: AND IRESDV.RESI_CATEGORY_SET_ID = RCSV.RESI_CATEGORY_SET_ID
1574: AND RCSV.STS_CODE <> p_rcs_sts_code

Line 1578: l_source_type OKL_FE_ITEM_RESIDUAL_ALL.CATEGORY_TYPE_CODE%TYPE;

1574: AND RCSV.STS_CODE <> p_rcs_sts_code
1575: AND IRESDV.item_residual_id = p_itm_rsdl_id;
1576:
1577: l_item_residual_id NUMBER;
1578: l_source_type OKL_FE_ITEM_RESIDUAL_ALL.CATEGORY_TYPE_CODE%TYPE;
1579: l_rcs_rec check_active_resi_cat_sets%ROWTYPE;
1580:
1581: BEGIN
1582: l_debug_enabled := okl_debug_pub.check_log_enabled;