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 672: FROM wip_entities we

668: , we.wip_entity_name
669: INTO l_item_id
670: , l_orgn_id
671: , l_job_name
672: FROM wip_entities we
673: WHERE we.gen_object_id = p_object_id;
674:
675: IF (l_item_id IS NOT NULL) THEN
676: SELECT concatenated_segments

Line 725: FROM wip_entities

721: WHERE header_id = p_trx_src_id;
722: ELSIF p_trx_src_type = 5 THEN -- WIP
723: SELECT wip_entity_name
724: INTO l_trx_src
725: FROM wip_entities
726: WHERE wip_entity_id = p_trx_src_id
727: AND organization_id = p_org_id;
728: ELSIF p_trx_src_type = 6 THEN -- Account Alias
729: SELECT SUBSTR(concatenated_segments, 1, 30)

Line 773: FROM wip_entities

769:
770: IF row_count > 0 THEN
771: SELECT wip_entity_name
772: INTO l_trx_src
773: FROM wip_entities
774: WHERE wip_entity_id = p_trx_src_id
775: AND organization_id = p_org_id;
776: END IF;
777: END IF;