[Home] [Help]
492: (
493: select P_DML_RECORD.REQUEST_ID,
494: P_DML_RECORD.BATCH_ID,
495: l_row_id(j),
496: 'HZ_IMP_PARTIES_INT',
497: HZ_IMP_ERRORS_S.NextVal,
498: P_DML_RECORD.SYSDATE,
499: P_DML_RECORD.USER_ID,
500: P_DML_RECORD.SYSDATE,
618: (
619: select P_DML_RECORD.REQUEST_ID,
620: P_DML_RECORD.BATCH_ID,
621: p_sg.int_row_id,
622: 'HZ_IMP_PARTIES_INT',
623: HZ_IMP_ERRORS_S.NextVal,
624: P_DML_RECORD.SYSDATE,
625: P_DML_RECORD.USER_ID,
626: P_DML_RECORD.SYSDATE,
1838: hz_imp_errors_s.nextval,
1839: :12, -- batch_id
1840: :7, -- request_id
1841: row_id,
1842: ''HZ_IMP_PARTIES_INT'',
1843: month_error,
1844: legal_status_error,
1845: local_bus_iden_type_error,
1846: reg_type_error,
2507: else null end sic_code,
2508: nvl2(nullif(nacfi.class_code, :16), 4, null) local_activity_code_type,
2509: nullif(nacfi.class_code, :16) local_activity_code
2510: from hz_imp_parties_sg ps,
2511: hz_imp_parties_int pi,
2512: hz_imp_addresses_sg ads,
2513: hz_imp_addresses_int adi,
2514: hz_imp_contactpts_sg webs,
2515: hz_imp_contactpts_int webi,
3225: p.status status,
3226: ps.party_id,
3227: ps.new_osr_exists_flag,
3228: ps.old_orig_system_reference
3229: FROM HZ_IMP_PARTIES_INT pi, HZ_IMP_PARTIES_SG ps, HZ_PARTIES p,
3230: HZ_PERSON_PROFILES pp,
3231: HZ_ORGANIZATION_PROFILES op,
3232: fnd_lookup_values party_type_l,
3233: fnd_lookup_values month_l,
9442: FND_GLOBAL.User_ID CREATED_BY,
9443: SYSDATE LAST_UPDATE_DATE,
9444: FND_GLOBAL.User_ID LAST_UPDATED_BY,
9445: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
9446: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint
9447: WHERE party.request_id = p_request_id
9448: AND party.party_id = ps.party_id
9449: AND ps.batch_mode_flag = p_batch_mode_flag
9450: AND ps.batch_id = p_batch_id