APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1235: l_uom_code mtl_system_items.primary_uom_code%TYPE;

1231: AND c.cle_id = a.id;
1232: --end: 02-APR-07 cklee R12 Billing enhancement project |
1233:
1234: l_inv_id NUMBER;
1235: l_uom_code mtl_system_items.primary_uom_code%TYPE;
1236:
1237: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
1238: SELECT c.OBJECT1_ID1
1239: FROM okc_k_lines_b a,

Line 1249: FROM mtl_system_items

1245: AND a.id = c.cle_id;
1246:
1247: CURSOR get_uom_code ( p_inv_item_id NUMBER ) IS
1248: SELECT primary_uom_code
1249: FROM mtl_system_items
1250: WHERE inventory_item_id = p_inv_item_id;
1251:
1252: CURSOR tax_exmpt_csr ( p_flg VARCHAR2 ) IS
1253: SELECT decode(p_flg,'S','S','E','E','R','R','S')