APPS.OKL_AM_ASSET_RETURN_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1577: mtl_system_items_b msi,

1573: kle.chr_id chr_id,
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

Line 1628: FROM MTL_SYSTEM_ITEMS_B

1624: -- check if item already exists in inventory
1625:
1626: CURSOR l_mtlsystemitems_csr(cp_inv_item_number IN VARCHAR2) IS
1627: SELECT 'x'
1628: FROM MTL_SYSTEM_ITEMS_B
1629: WHERE segment1 = cp_inv_item_number;
1630:
1631: -- check the Remarketing flow option from the setup
1632: CURSOR l_systemparamsall_csr IS

Line 1697: MTL_SYSTEM_ITEMS_B MTLB ,

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,
1699: HR_OPERATING_UNITS HROU
1700: WHERE kle.id = p_kle_id
1701: AND cle.cle_id = kle.id