DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ORIG_SYS_REFERENCES

Line 407: FROM HZ_ORIG_SYS_REFERENCES

403: ATTRIBUTE18,
404: ATTRIBUTE19,
405: ATTRIBUTE20
406: )
407: FROM HZ_ORIG_SYS_REFERENCES
408: WHERE OWNER_TABLE_ID = mph.from_entity_id
409: AND OWNER_TABLE_NAME = md.entity_name
410:
411: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

Line 456: FROM HZ_ORIG_SYS_REFERENCES

452: ATTRIBUTE18,
453: ATTRIBUTE19,
454: ATTRIBUTE20
455: )
456: FROM HZ_ORIG_SYS_REFERENCES
457: WHERE OWNER_TABLE_ID = decode(mph.operation_type,'Copy',mph.from_entity_id,mph.to_entity_id)
458: AND OWNER_TABLE_NAME = md.entity_name
459:
460: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

Line 505: FROM HZ_ORIG_SYS_REFERENCES

501: ATTRIBUTE18,
502: ATTRIBUTE19,
503: ATTRIBUTE20
504: )
505: FROM HZ_ORIG_SYS_REFERENCES
506: WHERE OWNER_TABLE_ID = mph.from_parent_entity_id
507: AND OWNER_TABLE_NAME = md.parent_entity_name
508:
509: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

Line 555: FROM HZ_ORIG_SYS_REFERENCES

551: ATTRIBUTE18,
552: ATTRIBUTE19,
553: ATTRIBUTE20
554: )
555: FROM HZ_ORIG_SYS_REFERENCES
556: WHERE OWNER_TABLE_ID = mph.to_parent_entity_id
557: AND OWNER_TABLE_NAME = md.parent_entity_name
558:
559: )AS HZ_ORIG_SYS_REF_OBJ_TBL)