eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_BATCH_IMPORT_PKG dependencies on HZ_ORIG_SYS_REFERENCES

Line 109: FROM hz_orig_sys_references hr

105: l_party_id NUMBER;
106: BEGIN
107: SELECT owner_table_id
108: INTO l_party_id
109: FROM hz_orig_sys_references hr
110: WHERE hr.owner_table_name = 'HZ_PARTIES'
111: AND hr.orig_system = p_orig_system
112: AND hr.orig_system_reference = p_orig_system_reference
113: AND hr.status = 'A'

Line 144: FROM hz_orig_sys_references hr

140: -- source id, source reference in cross reference table and update the ap_suppliers_int table
141: UPDATE ap_suppliers_int supp
142: SET party_id =
143: (SELECT party_id
144: FROM hz_orig_sys_references hr
145: WHERE hr.owner_table_name = 'HZ_PARTIES'
146: AND hr.orig_system = supp.party_orig_system
147: AND hr.orig_system_reference =
148: supp.party_orig_system_reference

Line 242: FROM hz_orig_sys_references hr

238:
239: UPDATE ap_supplier_sites_int supp
240: SET party_site_id =
241: (SELECT owner_table_id
242: FROM hz_orig_sys_references hr
243: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'
244: AND hr.party_id = supp.party_id -- Bug 14772702: Same site orig reference can exist under different suppliers
245: AND hr.orig_system = supp.party_site_orig_system
246: AND hr.orig_system_reference =

Line 404: FROM hz_orig_sys_references hr

400:
401: UPDATE ap_sup_site_contact_int supp
402: SET per_party_id =
403: (SELECT party_id
404: FROM hz_orig_sys_references hr
405: WHERE hr.owner_table_name = 'HZ_PARTIES'
406: AND hr.orig_system = supp.contact_orig_system
407: AND hr.orig_system_reference =
408: supp.contact_orig_system_reference

Line 1048: FROM hz_orig_sys_references hr

1044:
1045: UPDATE ap_suppliers_int supp
1046: SET supp.party_id =
1047: (SELECT party_id
1048: FROM hz_orig_sys_references hr
1049: WHERE hr.owner_table_name = 'HZ_PARTIES'
1050: AND hr.orig_system = supp.party_orig_system
1051: AND hr.orig_system_reference =
1052: supp.party_orig_system_reference

Line 1089: FROM hz_orig_sys_references hr

1085:
1086: UPDATE ap_supplier_sites_int supp
1087: SET supp.party_id =
1088: (SELECT party_id
1089: FROM hz_orig_sys_references hr
1090: WHERE hr.owner_table_name = 'HZ_PARTIES'
1091: AND hr.orig_system = supp.party_orig_system
1092: AND hr.orig_system_reference =
1093: supp.party_orig_system_reference

Line 1102: FROM hz_orig_sys_references hr

1098:
1099: UPDATE ap_supplier_sites_int supp
1100: SET party_site_id =
1101: (SELECT owner_table_id
1102: FROM hz_orig_sys_references hr
1103: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'
1104: AND hr.orig_system = supp.party_site_orig_system
1105: AND hr.orig_system_reference =
1106: supp.party_site_orig_sys_reference

Line 3986: FROM hz_orig_sys_references hr

3982:
3983: BEGIN
3984: SELECT owner_table_id
3985: INTO vendor_contact_rec.org_party_site_id
3986: FROM hz_orig_sys_references hr
3987: WHERE hr.owner_table_name = 'HZ_PARTY_SITES'
3988: AND hr.orig_system = contact_int_rec.party_site_orig_system
3989: AND hr.orig_system_reference =
3990: contact_int_rec.party_site_orig_sys_reference

Line 8992: FROM hz_orig_sys_references

8988:
8989: -- Get the party site id
8990: SELECT owner_table_id
8991: INTO l_party_site_id
8992: FROM hz_orig_sys_references
8993: WHERE orig_system = bank_account_dtls_rec.party_site_orig_sys
8994: AND orig_system_reference =
8995: bank_account_dtls_rec.party_site_orig_sys_ref
8996: AND owner_table_name = 'HZ_PARTY_SITES'