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.IMC_CSV_LOAD dependencies on HZ_IMP_ADDRESSES_INT

Line 91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;

87: STATE imc_csv_interface_fields.STATE%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;

Line 93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;

89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;

Line 94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;

90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;

Line 971: insert into HZ_IMP_ADDRESSES_INT(batch_id,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,SITE_ORIG_SYSTEM,

967: open get_next_ref_id;
968: fetch get_next_ref_id into SITE_ORIG_SYSTEM_REFERENCE;
969: close get_next_ref_id;
970:
971: insert into HZ_IMP_ADDRESSES_INT(batch_id,PARTY_ORIG_SYSTEM,PARTY_ORIG_SYSTEM_REFERENCE,SITE_ORIG_SYSTEM,
972: SITE_ORIG_SYSTEM_REFERENCE,COUNTRY,ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,CITY,
973: POSTAL_CODE,STATE,PROVINCE,COUNTY,ADDRESS_LINES_PHONETIC,LOCATION_DIRECTIONS,DESCRIPTION,SALES_TAX_GEOCODE,
974: PRIMARY_FLAG,PARTY_SITE_NAME,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
975: values(batchId,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,'CSV',SITE_ORIG_SYSTEM_REFERENCE,COUNTRY,ADDRESS1,ADDRESS2,