APPS.ASO_SERVICE_CONTRACTS_INT dependencies on MTL_SYSTEM_ITEMS_B

Line 33: from MTL_SYSTEM_ITEMS_B

29:
30: /* 2633507 - hyang: using cursor variable and base table */
31: CURSOR C_item1(inv1 NUMBER, lc_organization_id NUMBER) IS
32: select SERVICEABLE_PRODUCT_FLAG
33: from MTL_SYSTEM_ITEMS_B
34: where inventory_item_id = inv1
35: and organization_id = lc_organization_id;
36: CURSOR C_qln(c_qln_id NUMBER) IS
37: SELECT b.inventory_item_id,b.organization_id,a.cust_account_id

Line 58: csi_item_instances a, mtl_system_items_b b

54:
55: CURSOR C_cs_item(p_instance_id NUMBER, cs_org_id NUMBER) IS
56: SELECT a.inventory_item_id
57: FROM
58: csi_item_instances a, mtl_system_items_b b
59: WHERE a.inventory_item_id = b.inventory_item_id
60: AND a.instance_id = p_instance_id
61: AND b.organization_id = cs_org_id ;
62: