APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on WIP_ENTITIES

Line 105: FROM wip_entities

101: GROUP BY item_description, description;
102:
103: CURSOR wip_entity_name_csr(p_wip_entity_id NUMBER) IS
104: SELECT wip_entity_name
105: FROM wip_entities
106: WHERE wip_entity_id = p_wip_entity_id;
107:
108: CURSOR get_yes_no(p_lookup_code NUMBER) IS
109: SELECT meaning

Line 138: l_wip_entity_name wip_entities.wip_entity_name%TYPE;

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