APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ORIG_SYS_REF_OBJ

Line 90: HZ_ORIG_SYS_REF_OBJ_TBL()),

86: tp.party_id,
87: tp.party_number,
88: tp.party_name,
89: tp.party_type,
90: HZ_ORIG_SYS_REF_OBJ_TBL()),
91: HZ_PARTY_ORIG_SYS_REF_OBJ(
92: fp.party_id,
93: fp.party_number,
94: fp.party_name,

Line 96: HZ_ORIG_SYS_REF_OBJ_TBL()),

92: fp.party_id,
93: fp.party_number,
94: fp.party_name,
95: fp.party_type,
96: HZ_ORIG_SYS_REF_OBJ_TBL()),
97: HZ_ACCT_ORIG_SYS_REF_OBJ(
98: ta.cust_account_id,
99: ta.account_name,
100: ta.account_number,

Line 101: HZ_ORIG_SYS_REF_OBJ_TBL()),

97: HZ_ACCT_ORIG_SYS_REF_OBJ(
98: ta.cust_account_id,
99: ta.account_name,
100: ta.account_number,
101: HZ_ORIG_SYS_REF_OBJ_TBL()),
102: CAST(MULTISET (
103: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
104: fa.cust_account_id,
105: fa.account_name,

Line 107: HZ_ORIG_SYS_REF_OBJ_TBL())

103: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
104: fa.cust_account_id,
105: fa.account_name,
106: fa.account_number,
107: HZ_ORIG_SYS_REF_OBJ_TBL())
108: FROM hz_cust_accounts fa
109: WHERE fa.cust_account_id = mh.duplicate_id
110: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)
111: )

Line 335: HZ_ORIG_SYS_REF_OBJ_TBL()),

331: tp.party_id,
332: tp.party_number,
333: tp.party_name,
334: tp.party_type,
335: HZ_ORIG_SYS_REF_OBJ_TBL()),
336: CAST(MULTISET(
337: SELECT HZ_PARTY_ORIG_SYS_REF_OBJ(
338: fp.party_id,
339: fp.party_number,

Line 342: HZ_ORIG_SYS_REF_OBJ_TBL())

338: fp.party_id,
339: fp.party_number,
340: fp.party_name,
341: fp.party_type,
342: HZ_ORIG_SYS_REF_OBJ_TBL())
343: FROM hz_parties fp, hz_merge_parties mp1
344: WHERE mp1.batch_id = p_batch_id
345: AND mp1.to_party_id = p_merge_to_party_id
346: AND fp.party_id = mp1.from_party_id

Line 367: SELECT HZ_ORIG_SYS_REF_OBJ(

363: get_object_type(md.entity_name, mph.from_entity_id),
364: mph.operation_type,
365: mph.from_entity_id,
366: CAST(MULTISET(
367: SELECT HZ_ORIG_SYS_REF_OBJ(
368: NULL,
369: ORIG_SYSTEM_REF_ID,
370: ORIG_SYSTEM,
371: ORIG_SYSTEM_REFERENCE,

Line 411: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

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),
412:
413: mph.to_entity_id,
414:
415: CAST(MULTISET(

Line 416: SELECT HZ_ORIG_SYS_REF_OBJ(

412:
413: mph.to_entity_id,
414:
415: CAST(MULTISET(
416: SELECT HZ_ORIG_SYS_REF_OBJ(
417: NULL,
418: ORIG_SYSTEM_REF_ID,
419: ORIG_SYSTEM,
420: ORIG_SYSTEM_REFERENCE,

Line 460: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

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),
461:
462: mph.from_parent_entity_id,
463:
464: CAST(MULTISET(

Line 465: SELECT HZ_ORIG_SYS_REF_OBJ(

461:
462: mph.from_parent_entity_id,
463:
464: CAST(MULTISET(
465: SELECT HZ_ORIG_SYS_REF_OBJ(
466: NULL,
467: ORIG_SYSTEM_REF_ID,
468: ORIG_SYSTEM,
469: ORIG_SYSTEM_REFERENCE,

Line 509: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

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),
510:
511: mph.to_parent_entity_id,
512:
513:

Line 515: SELECT HZ_ORIG_SYS_REF_OBJ(

511: mph.to_parent_entity_id,
512:
513:
514: CAST(MULTISET(
515: SELECT HZ_ORIG_SYS_REF_OBJ(
516: NULL,
517: ORIG_SYSTEM_REF_ID,
518: ORIG_SYSTEM,
519: ORIG_SYSTEM_REFERENCE,

Line 559: )AS HZ_ORIG_SYS_REF_OBJ_TBL)

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)
560:
561: )
562: FROM hz_merge_parties mp2,
563: hz_merge_party_history mph,