APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on WIP_ENTITIES

Line 109: FROM wip_entities

105: GROUP BY item_description, description;
106:
107: CURSOR wip_entity_name_csr(p_wip_entity_id NUMBER) IS
108: SELECT wip_entity_name
109: FROM wip_entities
110: WHERE wip_entity_id = p_wip_entity_id;
111:
112: CURSOR get_yes_no(p_lookup_code NUMBER) IS
113: SELECT meaning

Line 142: l_wip_entity_name wip_entities.wip_entity_name%TYPE;

138: l_asset_sub_only BOOLEAN;
139: l_api_version CONSTANT NUMBER:=1;
140: l_api_name VARCHAR2(100);
141: l_unexpected_excep EXCEPTION;
142: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
143: l_asset_number csi_item_instances.instance_number%TYPE;
144: l_yes_no mfg_lookups.meaning%TYPE;
145: BEGIN
146: l_asset_sub_only := FALSE;