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_SERVICE_INTEGRATION_PVT dependencies on OKL_LA_COV_ASSET_UV

Line 2621: p_asset OKL_LA_COV_ASSET_UV.NAME%TYPE) IS

2617:
2618:
2619: CURSOR cov_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2620: p_srv_top_id OKC_K_LINES_V.ID%TYPE,
2621: p_asset OKL_LA_COV_ASSET_UV.NAME%TYPE) IS
2622: SELECT 'Y',
2623: item_description,
2624: srv_prod_instance_id
2625: FROM okl_la_cov_asset_uv

Line 2625: FROM okl_la_cov_asset_uv

2621: p_asset OKL_LA_COV_ASSET_UV.NAME%TYPE) IS
2622: SELECT 'Y',
2623: item_description,
2624: srv_prod_instance_id
2625: FROM okl_la_cov_asset_uv
2626: WHERE chr_id = p_chr_id
2627: AND serv_top_line_id = p_srv_top_id
2628: AND name = p_asset;
2629:

Line 2631: l_instance_id OKL_LA_COV_ASSET_UV.srv_prod_instance_id%TYPE;

2627: AND serv_top_line_id = p_srv_top_id
2628: AND name = p_asset;
2629:
2630: l_ok VARCHAR2(1);
2631: l_instance_id OKL_LA_COV_ASSET_UV.srv_prod_instance_id%TYPE;
2632: l_item_description OKL_LA_COV_ASSET_UV.item_description%TYPE;
2633:
2634: BEGIN -- main process begins here
2635: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 2632: l_item_description OKL_LA_COV_ASSET_UV.item_description%TYPE;

2628: AND name = p_asset;
2629:
2630: l_ok VARCHAR2(1);
2631: l_instance_id OKL_LA_COV_ASSET_UV.srv_prod_instance_id%TYPE;
2632: l_item_description OKL_LA_COV_ASSET_UV.item_description%TYPE;
2633:
2634: BEGIN -- main process begins here
2635: IF (G_DEBUG_ENABLED = 'Y') THEN
2636: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 2813: p_asset OKL_LA_COV_ASSET_UV.NAME%TYPE) IS

2809:
2810:
2811: CURSOR cov_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2812: p_srv_top_id OKC_K_LINES_V.ID%TYPE,
2813: p_asset OKL_LA_COV_ASSET_UV.NAME%TYPE) IS
2814: SELECT 'Y'
2815: FROM okl_la_cov_asset_uv
2816: WHERE chr_id = p_chr_id
2817: AND serv_top_line_id = p_srv_top_id

Line 2815: FROM okl_la_cov_asset_uv

2811: CURSOR cov_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2812: p_srv_top_id OKC_K_LINES_V.ID%TYPE,
2813: p_asset OKL_LA_COV_ASSET_UV.NAME%TYPE) IS
2814: SELECT 'Y'
2815: FROM okl_la_cov_asset_uv
2816: WHERE chr_id = p_chr_id
2817: AND serv_top_line_id = p_srv_top_id
2818: AND name = p_asset;
2819:

Line 3140: l_item_desc OKL_LA_COV_ASSET_UV.item_description%TYPE;

3136:
3137: l_oks_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3138: l_oks_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3139:
3140: l_item_desc OKL_LA_COV_ASSET_UV.item_description%TYPE;
3141:
3142: BEGIN -- main process begins here
3143: IF (G_DEBUG_ENABLED = 'Y') THEN
3144: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 3418: FROM okl_la_cov_asset_uv

3414:
3415: CURSOR serial_csr (p_srv_line_id OKC_K_LINES_B.ID%TYPE,
3416: p_asset_id OKC_K_LINES_B.ID%TYPE) IS
3417: SELECT *
3418: FROM okl_la_cov_asset_uv
3419: WHERE serv_top_line_id = p_srv_line_id
3420: AND id1 = p_asset_id
3421: AND serial_number_control_code <> 1;
3422:

Line 3599: FROM okl_la_cov_asset_uv cov_asset

3595: id1,
3596: id2 --,
3597: --lease_item_qty,
3598: --service_item_qty
3599: FROM okl_la_cov_asset_uv cov_asset
3600: WHERE oks_cov_line_id = p_oks_cov_line_id
3601: AND serv_top_line_id = p_okl_serv_line_id
3602: -- bug 4889070. START
3603: AND lease_item_qty = service_item_qty

Line 3616: FROM okl_la_cov_asset_uv

3612: AND line.sts_code <> 'ABANDONED');
3613:
3614: CURSOR check_serial_csr (p_okl_service_id OKC_K_LINES_V.ID%TYPE) IS
3615: SELECT distinct id1
3616: FROM okl_la_cov_asset_uv
3617: WHERE serv_top_line_id = p_okl_service_id
3618: AND serial_number_control_code <> 1; -- serial item
3619:
3620: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

Line 3623: l_asset_number okl_la_cov_asset_uv.name%TYPE;

3619:
3620: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3621: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3622: i NUMBER := 0;
3623: l_asset_number okl_la_cov_asset_uv.name%TYPE;
3624: l_id1 okl_la_cov_asset_uv.id1%TYPE;
3625: l_id2 okl_la_cov_asset_uv.id2%TYPE;
3626:
3627: -- bug 4889070 commented local vars as they are no longer reqd

Line 3624: l_id1 okl_la_cov_asset_uv.id1%TYPE;

3620: l_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3621: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3622: i NUMBER := 0;
3623: l_asset_number okl_la_cov_asset_uv.name%TYPE;
3624: l_id1 okl_la_cov_asset_uv.id1%TYPE;
3625: l_id2 okl_la_cov_asset_uv.id2%TYPE;
3626:
3627: -- bug 4889070 commented local vars as they are no longer reqd
3628: -- l_lease_item_qty NUMBER;

Line 3625: l_id2 okl_la_cov_asset_uv.id2%TYPE;

3621: x_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3622: i NUMBER := 0;
3623: l_asset_number okl_la_cov_asset_uv.name%TYPE;
3624: l_id1 okl_la_cov_asset_uv.id1%TYPE;
3625: l_id2 okl_la_cov_asset_uv.id2%TYPE;
3626:
3627: -- bug 4889070 commented local vars as they are no longer reqd
3628: -- l_lease_item_qty NUMBER;
3629: -- l_service_item_qty NUMBER;