APPS.EAM_MATERIAL_VALIDATE_PVT dependencies on WIP_ENTITIES

Line 38: FROM wip_entities

34: RETURN VARCHAR2
35: IS
36: CURSOR wip_entity_name_csr(p_wip_entity_id NUMBER) IS
37: SELECT wip_entity_name
38: FROM wip_entities
39: WHERE wip_entity_id = p_wip_entity_id;
40:
41: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
42: BEGIN

Line 41: l_wip_entity_name wip_entities.wip_entity_name%TYPE;

37: SELECT wip_entity_name
38: FROM wip_entities
39: WHERE wip_entity_id = p_wip_entity_id;
40:
41: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
42: BEGIN
43: OPEN wip_entity_name_csr(p_wip_entity_id);
44: FETCH wip_entity_name_csr INTO l_wip_entity_name;
45: CLOSE wip_entity_name_csr;

Line 108: FROM wip_discrete_jobs wdj, eam_work_order_details ewod, wip_entities we, csi_item_instances cii

104: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' );
106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
107: l_sql_stmt := ' SELECT wdj.wip_entity_id
108: FROM wip_discrete_jobs wdj, eam_work_order_details ewod, wip_entities we, csi_item_instances cii
109: WHERE wdj.wip_entity_id = ewod.wip_entity_id
110: AND wdj.wip_entity_id=we.wip_entity_id
111: AND wdj.maintenance_object_id = cii.instance_id
112: AND wdj.maintenance_object_type = 3