APPS.OKL_AM_ASSET_RETURN_PVT dependencies on OKC_K_LINES_B

Line 1432: FROM okc_k_lines_b

1428:
1429: -- This cursor to used to check the status of the asset line
1430: CURSOR l_okclines_csr IS
1431: SELECT sts_code
1432: FROM okc_k_lines_b
1433: WHERE id = p_kle_id;
1434:
1435: l_sts_code okc_k_lines_b.sts_code%TYPE;
1436: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_asset_status';

Line 1435: l_sts_code okc_k_lines_b.sts_code%TYPE;

1431: SELECT sts_code
1432: FROM okc_k_lines_b
1433: WHERE id = p_kle_id;
1434:
1435: l_sts_code okc_k_lines_b.sts_code%TYPE;
1436: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_asset_status';
1437: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1438: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1439: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 1578: okc_k_lines_b kle2,

1574: msi.segment1 inventory_item_number
1575: FROM okl_k_lines_full_v kle,
1576: okl_asset_returns_all_b oar,
1577: mtl_system_items_b msi,
1578: okc_k_lines_b kle2,
1579: okc_line_styles_b lse,
1580: okc_k_items cim
1581: WHERE oar.kle_id = kle.id
1582: AND oar.imr_id = msi.inventory_item_id(+)

Line 1681: FROM okc_k_lines_b

1677: -- Legal Entity Changes
1678: -- Bug 6674730 start
1679: CURSOR l_okclines_csr(p_kle_id NUMBER) IS
1680: SELECT sts_code
1681: FROM okc_k_lines_b
1682: WHERE id = p_kle_id;
1683:
1684: l_sts_code okc_k_lines_b.sts_code%TYPE;
1685: l_deal_type VARCHAR2(150);

Line 1684: l_sts_code okc_k_lines_b.sts_code%TYPE;

1680: SELECT sts_code
1681: FROM okc_k_lines_b
1682: WHERE id = p_kle_id;
1683:
1684: l_sts_code okc_k_lines_b.sts_code%TYPE;
1685: l_deal_type VARCHAR2(150);
1686: -- Bug 6674730 end
1687:
1688: -- rmunjulu 6674730

Line 1694: FROM OKC_K_LINES_B CLE,

1690: SELECT cle.id ID,
1691: mtlb.description item_description,
1692: mtlb.asset_category_id asset_category_id,
1693: hrou.name organization_name
1694: FROM OKC_K_LINES_B CLE,
1695: OKC_K_ITEMS CIM,
1696: OKC_LINE_STYLES_B LSE,
1697: MTL_SYSTEM_ITEMS_B MTLB ,
1698: OKC_K_LINES_B KLE,

Line 1698: OKC_K_LINES_B KLE,

1694: FROM OKC_K_LINES_B CLE,
1695: OKC_K_ITEMS CIM,
1696: OKC_LINE_STYLES_B LSE,
1697: MTL_SYSTEM_ITEMS_B MTLB ,
1698: OKC_K_LINES_B KLE,
1699: HR_OPERATING_UNITS HROU
1700: WHERE kle.id = p_kle_id
1701: AND cle.cle_id = kle.id
1702: AND cle.id = cim.cle_id