APPS.IEM_EMAIL_PROC_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 7436: --and inventory_item_id is of mtl_system_items_b.serv_req_enabled_code = 'E'

7432: iem_logger(l_logmessage);
7433: --dbms_output.put_line(l_logmessage);
7434: END;
7435:
7436: --and inventory_item_id is of mtl_system_items_b.serv_req_enabled_code = 'E'
7437: ELSIF p_instance_number is not null then
7438: BEGIN
7439: select distinct owner_party_id
7440: into x_customer_id

Line 7943: --Item must inventroy_item_id of (mtl_system_items_b.serv_req_enabled_code = 'E').

7939: IS
7940: l_instance_count number;
7941: l_logmessage varchar2(2000):=' ';
7942: BEGIN
7943: --Item must inventroy_item_id of (mtl_system_items_b.serv_req_enabled_code = 'E').
7944: -- The item must not be a service item (contract_item_type_code is Null).
7945: IF g_customer_id IS NULL THEN
7946: getCustomerNumber ( p_instance_number => p_instance_number,
7947: x_customer_id => g_customer_id);

Line 8082: --(mtl_system_items_b.serv_req_enabled_code = 'E').

8078: l_instance_count number;
8079: l_logmessage varchar2(2000):=' ';
8080: BEGIN
8081: --Item must inventroy_item_id of
8082: --(mtl_system_items_b.serv_req_enabled_code = 'E').
8083: -- The item must not be a service item (contract_item_type_code is Null).
8084: --IGNORE this section as we should have already found the customer_id but
8085: --leaving the code here for futere purpose if we change our mind
8086: IF g_customer_id IS NULL THEN

Line 8810: from mtl_system_items_b

8806:
8807: BEGIN
8808: select DISTINCT inventory_item_id, organization_id
8809: into x_inventory_item_id, x_inventory_org_id
8810: from mtl_system_items_b
8811: where organization_id=FND_PROFILE.value('CS_INV_VALIDATION_ORG') and
8812: upper(segment1)= upper(p_inventory_item_name);
8813:
8814: l_logmessage:='inventoryItemName is '||p_inventory_item_name||' inventory_item_id is '|| x_inventory_item_id;