[Home] [Help]
843: hz_imp_errors_s.nextval,
844: :10,
845: :3,
846: row_id,
847: ''HZ_IMP_ADDRESSES_INT'',
848: action_mismatch_error,
849: nvl2(owner_table_id, ''Y'', null),
850: nvl2(error_flag, DECODE(error_flag,3,''Y'', null), ''Y''),
851: address_error,
947: site_int.attribute10, site_int.attribute11, site_int.attribute12, site_int.attribute13, site_int.attribute14,
948: site_int.attribute15, site_int.attribute16, site_int.attribute17, site_int.attribute18, site_int.attribute19,
949: site_int.attribute20, :5, :2
950: ), ''T'') flex_val_error
951: FROM HZ_IMP_ADDRESSES_INT site_int,
952: HZ_IMP_ADDRESSES_SG site_sg,
953: FND_TERRITORIES fnd_terr,
954: FND_TERRITORIES fnd_terr2,
955: (select language_code
1046: from HZ_IMP_TMP_ERRORS err_table,
1047: hz_imp_addresses_sg addr_sg,
1048: hz_party_sites hz_ps
1049: where err_table.request_id = :request_id
1050: and interface_table_name = ''HZ_IMP_ADDRESSES_INT''
1051: and addr_sg.batch_id = :batch_id
1052: and addr_sg.batch_mode_flag = :batch_mode_flag
1053: and addr_sg.party_orig_system = :orig_system
1054: and addr_sg.party_orig_system_reference between :from_osr and :to_osr
1262: (
1263: select P_DML_RECORD.REQUEST_ID,
1264: P_DML_RECORD.BATCH_ID,
1265: fr_sg.int_row_id,
1266: 'HZ_IMP_ADDRESSES_INT',
1267: hz_imp_errors_s.NextVal,
1268: P_DML_RECORD.SYSDATE,
1269: P_DML_RECORD.USER_ID,
1270: P_DML_RECORD.SYSDATE,
1469: )
1470: ),
1471: ''Y'') createdby_error
1472:
1473: FROM HZ_IMP_ADDRESSES_INT site_int,
1474: HZ_IMP_ADDRESSES_SG site_sg,
1475: FND_TERRITORIES fnd_terr,
1476: FND_TERRITORIES fnd_terr2,
1477: ( select language_code
1700: )
1701: ),
1702: ''Y'') createdby_error
1703:
1704: FROM HZ_IMP_ADDRESSES_INT site_int,
1705: HZ_IMP_ADDRESSES_SG site_sg,
1706: FND_TERRITORIES fnd_terr,
1707: FND_TERRITORIES fnd_terr2,
1708: ( select language_code
3112: (
3113: select P_DML_RECORD.REQUEST_ID,
3114: P_DML_RECORD.BATCH_ID,
3115: l_row_id(j),
3116: 'HZ_IMP_ADDRESSES_INT',
3117: hz_imp_errors_s.NextVal,
3118: P_DML_RECORD.SYSDATE,
3119: P_DML_RECORD.USER_ID,
3120: P_DML_RECORD.SYSDATE,
3246: SYSDATE LAST_UPDATE_DATE,
3247: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3248: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3249: FROM HZ_PARTY_SITES ps, HZ_IMP_ADDRESSES_SG pssg,HZ_LOCATIONS loc, --4742586
3250: HZ_IMP_ADDRESSES_INT psint
3251: WHERE loc.request_id = p_request_id --Bug No.4956874.SQLID:14455142
3252: AND ps.party_site_id = pssg.party_site_id -- Bug 5210879.
3253: AND loc.location_id = ps.location_id --4742586
3254: AND pssg.batch_mode_flag = p_batch_mode_flag