DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 8062: FROM mtl_system_items

8058:
8059: CURSOR l_inv_item_csr(p_inv_item_id IN NUMBER,
8060: p_org_id IN NUMBER) IS
8061: SELECT asset_category_id
8062: FROM mtl_system_items
8063: WHERE inventory_item_id = p_inv_item_id
8064: AND organization_id = p_org_id;
8065:
8066: l_inv_item_rec l_inv_item_csr%ROWTYPE;

Line 8658: FROM mtl_system_items

8654:
8655: CURSOR l_inv_item_csr(p_inv_item_id IN NUMBER,
8656: p_org_id IN NUMBER) IS
8657: SELECT asset_category_id
8658: FROM mtl_system_items
8659: WHERE inventory_item_id = p_inv_item_id
8660: AND organization_id = p_org_id;
8661:
8662: l_inv_item_rec l_inv_item_csr%ROWTYPE;