APPS.INV_OBJECT_GENEALOGY dependencies on WIP_ENTITIES

Line 26: FROM wip_entities

22: WHEN NO_DATA_FOUND THEN
23: BEGIN
24: SELECT 5
25: INTO l_retval
26: FROM wip_entities
27: WHERE gen_object_id = p_object_id;
28: EXCEPTION
29: WHEN OTHERS THEN
30: l_retval := NULL;

Line 618: FROM wip_entities we

614: , we.wip_entity_name
615: INTO l_item_id
616: , l_orgn_id
617: , l_job_name
618: FROM wip_entities we
619: WHERE we.gen_object_id = p_object_id;
620:
621: IF (l_item_id IS NOT NULL) THEN
622: SELECT concatenated_segments

Line 671: FROM wip_entities

667: WHERE header_id = p_trx_src_id;
668: ELSIF p_trx_src_type = 5 THEN -- WIP
669: SELECT wip_entity_name
670: INTO l_trx_src
671: FROM wip_entities
672: WHERE wip_entity_id = p_trx_src_id
673: AND organization_id = p_org_id;
674: ELSIF p_trx_src_type = 6 THEN -- Account Alias
675: SELECT SUBSTR(concatenated_segments, 1, 30)

Line 719: FROM wip_entities

715:
716: IF row_count > 0 THEN
717: SELECT wip_entity_name
718: INTO l_trx_src
719: FROM wip_entities
720: WHERE wip_entity_id = p_trx_src_id
721: AND organization_id = p_org_id;
722: END IF;
723: END IF;