DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 7863: FROM mtl_system_items

7859:
7860: CURSOR l_inv_item_csr(p_inv_item_id IN NUMBER,
7861: p_org_id IN NUMBER) IS
7862: SELECT asset_category_id
7863: FROM mtl_system_items
7864: WHERE inventory_item_id = p_inv_item_id
7865: AND organization_id = p_org_id;
7866:
7867: l_inv_item_rec l_inv_item_csr%ROWTYPE;

Line 8459: FROM mtl_system_items

8455:
8456: CURSOR l_inv_item_csr(p_inv_item_id IN NUMBER,
8457: p_org_id IN NUMBER) IS
8458: SELECT asset_category_id
8459: FROM mtl_system_items
8460: WHERE inventory_item_id = p_inv_item_id
8461: AND organization_id = p_org_id;
8462:
8463: l_inv_item_rec l_inv_item_csr%ROWTYPE;