APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1027: l_uom_code mtl_system_items.primary_uom_code%TYPE;

1023: AND c.cle_id = a.id;
1024: --end: 02-APR-07 cklee R12 Billing enhancement project |
1025:
1026: l_inv_id NUMBER;
1027: l_uom_code mtl_system_items.primary_uom_code%TYPE;
1028:
1029: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
1030: SELECT c.OBJECT1_ID1
1031: FROM okc_k_lines_b a,

Line 1041: FROM mtl_system_items

1037: AND a.id = c.cle_id;
1038:
1039: CURSOR get_uom_code ( p_inv_item_id NUMBER ) IS
1040: SELECT primary_uom_code
1041: FROM mtl_system_items
1042: WHERE inventory_item_id = p_inv_item_id;
1043:
1044: CURSOR tax_exmpt_csr ( p_flg VARCHAR2 ) IS
1045: SELECT decode(p_flg,'S','S','E','E','R','R','S')