[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT o.ANALYSIS_FY
,o.AVG_HIGH_CREDIT
,o.BEST_TIME_CONTACT_BEGIN
,o.BEST_TIME_CONTACT_END
,o.BRANCH_FLAG
,o.BUSINESS_SCOPE
,o.CEO_NAME
,o.CEO_TITLE
,o.CONG_DIST_CODE
,o.CONTENT_SOURCE_NUMBER
,o.CONTENT_SOURCE_TYPE
,o.CONTROL_YR
,o.CORPORATION_CLASS
,o.CREDIT_SCORE
,o.CREDIT_SCORE_AGE
,o.CREDIT_SCORE_CLASS
,o.CREDIT_SCORE_COMMENTARY
,o.CREDIT_SCORE_COMMENTARY10
,o.CREDIT_SCORE_COMMENTARY2
,o.CREDIT_SCORE_COMMENTARY3
,o.CREDIT_SCORE_COMMENTARY4
,o.CREDIT_SCORE_COMMENTARY5
,o.CREDIT_SCORE_COMMENTARY6
,o.CREDIT_SCORE_COMMENTARY7
,o.CREDIT_SCORE_COMMENTARY8
,o.CREDIT_SCORE_COMMENTARY9
,o.CREDIT_SCORE_DATE
,o.CREDIT_SCORE_INCD_DEFAULT
,o.CREDIT_SCORE_NATL_PERCENTILE
,o.CURR_FY_POTENTIAL_REVENUE
,o.DB_RATING
,o.DEBARMENTS_COUNT
,o.DEBARMENTS_DATE
,o.DEBARMENT_IND
,o.DISADV_8A_IND
,o.DUNS_NUMBER_C
,o.EMPLOYEES_TOTAL
,o.EMP_AT_PRIMARY_ADR
,o.EMP_AT_PRIMARY_ADR_EST_IND
,o.EMP_AT_PRIMARY_ADR_MIN_IND
,o.EMP_AT_PRIMARY_ADR_TEXT
,o.ENQUIRY_DUNS
,o.EXPORT_IND
,o.FAILURE_SCORE
,o.FAILURE_SCORE_AGE
,o.FAILURE_SCORE_CLASS
,o.FAILURE_SCORE_COMMENTARY
,o.FAILURE_SCORE_COMMENTARY10
,o.FAILURE_SCORE_COMMENTARY2
,o.FAILURE_SCORE_COMMENTARY3
,o.FAILURE_SCORE_COMMENTARY4
,o.FAILURE_SCORE_COMMENTARY5
,o.FAILURE_SCORE_COMMENTARY6
,o.FAILURE_SCORE_COMMENTARY7
,o.FAILURE_SCORE_COMMENTARY8
,o.FAILURE_SCORE_COMMENTARY9
,o.FAILURE_SCORE_DATE
,o.FAILURE_SCORE_INCD_DEFAULT
,o.FAILURE_SCORE_OVERRIDE_CODE
,o.FISCAL_YEAREND_MONTH
,o.GLOBAL_FAILURE_SCORE
,o.GSA_INDICATOR_FLAG
,o.HIGH_CREDIT
,o.HQ_BRANCH_IND
,o.IMPORT_IND
,o.INCORP_YEAR
,o.INTERNAL_FLAG
,o.JGZZ_FISCAL_CODE
,o.LABOR_SURPLUS_IND
,o.LEGAL_STATUS
,o.LINE_OF_BUSINESS
,o.LOCAL_ACTIVITY_CODE
,o.LOCAL_ACTIVITY_CODE_TYPE
,o.LOCAL_BUS_IDENTIFIER
,o.LOCAL_BUS_IDEN_TYPE
,o.MAXIMUM_CREDIT_CURRENCY_CODE
,o.MAXIMUM_CREDIT_RECOMMENDATION
,o.MINORITY_OWNED_IND
,o.MINORITY_OWNED_TYPE
,o.NEXT_FY_POTENTIAL_REVENUE
,o.OOB_IND
,o.ORGANIZATION_NAME
,o.ORGANIZATION_NAME_PHONETIC
,o.ORGANIZATION_TYPE
,o.PARENT_SUB_IND
,o.PAYDEX_NORM
,o.PAYDEX_SCORE
,o.PAYDEX_THREE_MONTHS_AGO
,o.PREF_FUNCTIONAL_CURRENCY
,o.PRINCIPAL_NAME
,o.PRINCIPAL_TITLE
,o.PUBLIC_PRIVATE_OWNERSHIP_FLAG
,o.REGISTRATION_TYPE
,o.RENT_OWN_IND
,o.SIC_CODE
,o.SIC_CODE_TYPE
,o.SMALL_BUS_IND
,o.TAX_NAME
,o.TAX_REFERENCE
,o.TOTAL_EMPLOYEES_TEXT
,o.TOTAL_EMP_EST_IND
,o.TOTAL_EMP_MIN_IND
,o.TOTAL_EMPLOYEES_IND
,o.TOTAL_PAYMENTS
,o.WOMAN_OWNED_IND
,o.YEAR_ESTABLISHED
,p.CATEGORY_CODE
,p.COMPETITOR_FLAG
,p.DO_NOT_MAIL_FLAG
,p.GROUP_TYPE
,p.LANGUAGE_NAME
,p.PARTY_NAME
,p.PARTY_NUMBER
,p.PARTY_TYPE
,p.REFERENCE_USE_FLAG
,p.SALUTATION
,nvl(p.STATUS,'A')
,p.THIRD_PARTY_FLAG
,p.VALIDATED_FLAG
,o.EFFECTIVE_START_DATE
,o.EFFECTIVE_END_DATE
,p.KNOWN_AS
,p.KNOWN_AS2
,p.KNOWN_AS3
,p.KNOWN_AS4
,p.KNOWN_AS5
FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES o
WHERE p.party_id = p_party_id
AND o.effective_end_date is NULL
AND p.party_id = o.party_id;
SELECT p.CATEGORY_CODE
,p.COMPETITOR_FLAG
,p.DO_NOT_MAIL_FLAG
,p.GROUP_TYPE
,p.LANGUAGE_NAME
,p.PARTY_NAME
,p.PARTY_NUMBER
,p.PARTY_TYPE
,p.REFERENCE_USE_FLAG
,p.SALUTATION
,nvl(p.STATUS,'A')
,p.THIRD_PARTY_FLAG
,p.VALIDATED_FLAG
,pe.DATE_OF_BIRTH
,pe.DATE_OF_DEATH
,pe.DECLARED_ETHNICITY
,pe.GENDER
,pe.HEAD_OF_HOUSEHOLD_FLAG
,pe.HOUSEHOLD_INCOME
,pe.HOUSEHOLD_SIZE
,pe.LAST_KNOWN_GPS
,pe.MARITAL_STATUS
,pe.MARITAL_STATUS_EFFECTIVE_DATE
,pe.MIDDLE_NAME_PHONETIC
,pe.PERSONAL_INCOME
,pe.PERSON_ACADEMIC_TITLE
,pe.PERSON_FIRST_NAME
,pe.PERSON_FIRST_NAME_PHONETIC
,pe.PERSON_IDENTIFIER
,pe.PERSON_IDEN_TYPE
,pe.PERSON_INITIALS
,pe.PERSON_LAST_NAME
,pe.PERSON_LAST_NAME_PHONETIC
,pe.PERSON_MIDDLE_NAME
,pe.PERSON_NAME
,pe.PERSON_NAME_PHONETIC
,pe.PERSON_NAME_SUFFIX
,pe.PERSON_PREVIOUS_LAST_NAME
,pe.PERSON_PRE_NAME_ADJUNCT
,pe.PERSON_TITLE
,pe.PLACE_OF_BIRTH
,pe.BEST_TIME_CONTACT_BEGIN
,pe.BEST_TIME_CONTACT_END
,pe.CONTENT_SOURCE_NUMBER
,pe.CONTENT_SOURCE_TYPE
,pe.INTERNAL_FLAG
,pe.JGZZ_FISCAL_CODE
,pe.RENT_OWN_IND
,pe.TAX_NAME
,pe.TAX_REFERENCE
,pe.EFFECTIVE_START_DATE
,pe.EFFECTIVE_END_DATE
,p.KNOWN_AS
,p.KNOWN_AS2
,p.KNOWN_AS3
,p.KNOWN_AS4
,p.KNOWN_AS5
FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
WHERE p.party_id = p_party_id
AND pe.effective_end_date is NULL
AND p.party_id = pe.party_id;
SELECT attribute_name, custom_attribute_procedure
FROM HZ_TRANS_ATTRIBUTES_VL
WHERE entity_name='PARTY'
AND (source_table = 'CUSTOM'
OR custom_attribute_procedure is not null);
l_sql := 'select '|| g_party_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
SELECT l.ADDRESS1
,l.ADDRESS2
,l.ADDRESS3
,l.ADDRESS4
,l.ADDRESS_EFFECTIVE_DATE
,l.ADDRESS_EXPIRATION_DATE
,l.ADDRESS_LINES_PHONETIC
,l.CITY
,l.CLLI_CODE
,l.CONTENT_SOURCE_TYPE
,l.COUNTRY
,l.COUNTY
,l.FLOOR
,l.HOUSE_NUMBER
,l.LANGUAGE
,l.POSITION
,l.POSTAL_CODE
,l.POSTAL_PLUS4_CODE
,l.PO_BOX_NUMBER
,l.PROVINCE
,l.SALES_TAX_GEOCODE
,l.SALES_TAX_INSIDE_CITY_LIMITS
,l.STATE
,l.STREET
,l.STREET_NUMBER
,l.STREET_SUFFIX
,l.SUITE
,l.TRAILING_DIRECTORY_CODE
,l.VALIDATED_FLAG
,ps.IDENTIFYING_ADDRESS_FLAG
,ps.MAILSTOP
,ps.PARTY_SITE_NAME
,ps.PARTY_SITE_NUMBER
FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
WHERE ps.party_site_id = p_party_site_id
AND ps.location_id = l.location_id
AND (ps.status is null OR ps.status = 'A' or ps.status = 'I');
SELECT attribute_name, custom_attribute_procedure
FROM HZ_TRANS_ATTRIBUTES_VL
WHERE entity_name='PARTY_SITES'
AND (source_table = 'CUSTOM'
OR custom_attribute_procedure is not null);
l_sql := 'select '|| g_ps_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
SELECT o.CONTACT_NUMBER
,o.DECISION_MAKER_FLAG
,o.JOB_TITLE
,o.JOB_TITLE_CODE
,o.MAIL_STOP
,o.NATIVE_LANGUAGE
,o.OTHER_LANGUAGE_1
,o.OTHER_LANGUAGE_2
,o.RANK
,o.REFERENCE_USE_FLAG
,o.TITLE
,pr.RELATIONSHIP_TYPE
,ps.BEST_TIME_CONTACT_BEGIN
,ps.BEST_TIME_CONTACT_END
,ps.DATE_OF_BIRTH
,ps.DATE_OF_DEATH
,ps.JGZZ_FISCAL_CODE
,ps.KNOWN_AS
,ps.PERSON_ACADEMIC_TITLE
,ps.PERSON_FIRST_NAME
,ps.PERSON_FIRST_NAME_PHONETIC
,ps.PERSON_IDENTIFIER
,ps.PERSON_IDEN_TYPE
,ps.PERSON_INITIALS
,ps.PERSON_LAST_NAME
,ps.PERSON_LAST_NAME_PHONETIC
,ps.PERSON_MIDDLE_NAME
,ps.PERSON_NAME
,ps.PERSON_NAME_PHONETIC
,ps.PERSON_NAME_SUFFIX
,ps.PERSON_PREVIOUS_LAST_NAME
,ps.PERSON_TITLE
,ps.PLACE_OF_BIRTH
,ps.TAX_NAME
,ps.TAX_REFERENCE
FROM HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_PERSON_PROFILES ps
WHERE o.party_relationship_id = pr.relationship_id
AND pr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND pr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND pr.DIRECTIONAL_FLAG = 'F'
AND pr.subject_id = ps.party_id
AND ps.effective_end_date IS NULL
AND o.org_contact_id = p_org_contact_id
AND (o.status is null OR o.status = 'A' or o.status = 'I')
AND (pr.status is null OR pr.status = 'A' or pr.status = 'I');
SELECT attribute_name, custom_attribute_procedure
FROM HZ_TRANS_ATTRIBUTES_VL
WHERE entity_name='CONTACTS'
AND (source_table = 'CUSTOM'
OR custom_attribute_procedure is not null);
l_sql := 'select '|| g_cont_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
SELECT CONTACT_POINT_TYPE
,CONTENT_SOURCE_TYPE
,EDI_ECE_TP_LOCATION_CODE
,EDI_ID_NUMBER
,EDI_PAYMENT_FORMAT
,EDI_PAYMENT_METHOD
,EDI_REMITTANCE_INSTRUCTION
,EDI_REMITTANCE_METHOD
,EDI_TP_HEADER_ID
,EDI_TRANSACTION_HANDLING
,EMAIL_ADDRESS
,EMAIL_FORMAT
,LAST_CONTACT_DT_TIME
,PHONE_AREA_CODE
,PHONE_CALLING_CALENDAR
,PHONE_COUNTRY_CODE
,PHONE_EXTENSION
,PHONE_LINE_TYPE
,PHONE_NUMBER
,PRIMARY_FLAG
,TELEPHONE_TYPE
,TELEX_NUMBER
,TIME_ZONE
,URL
,WEB_TYPE
FROM HZ_CONTACT_POINTS
WHERE contact_point_id = p_contact_point_id
AND (status is null OR status = 'A' or status = 'I');
SELECT attribute_name, custom_attribute_procedure
FROM HZ_TRANS_ATTRIBUTES_VL
WHERE entity_name='CONTACT_POINTS'
AND (source_table = 'CUSTOM'
OR custom_attribute_procedure IS NOT NULL);
l_sql := 'select '|| g_cpt_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
SELECT ACCOUNT_NAME, ACCOUNT_NUMBER
FROM hz_cust_accounts
WHERE PARTY_ID = p_party_id
ORDER BY STATUS,CREATION_DATE;--Bug 9155543
SELECT PARTY_NAME || ' ' || KNOWN_AS || ' ' || KNOWN_AS2 || ' ' || KNOWN_AS3
|| ' '|| KNOWN_AS4 || ' '|| KNOWN_AS5, PARTY_NAME
FROM HZ_PARTIES
WHERE party_id = p_party_id;
SELECT rtrim(l.address1 || ' ' || l.address2 || ' ' ||
l.address3 || ' ' || l.address4), rtrim(l.address1)
FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
WHERE ps.party_site_id = p_party_site_id
AND ps.location_id = l.location_id;
select party_name
from HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_parties p
WHERE o.party_relationship_id = pr.relationship_id
AND pr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND pr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND pr.DIRECTIONAL_FLAG = 'F'
AND pr.subject_id = p.party_id
AND o.org_contact_id = p_org_contact_id
AND (o.status is null OR o.status = 'A' or o.status = 'I')
AND (pr.status is null OR pr.status = 'A' or pr.status = 'I');
SELECT PHONE_NUMBER, PHONE_AREA_CODE, PHONE_COUNTRY_CODE
FROM HZ_CONTACT_POINTS
WHERE contact_point_id = p_contact_pt_id;
( select orig_system, orig_system_reference
from
hz_orig_sys_references
where owner_table_name = decode(p_entity,
'PARTY','HZ_PARTIES',
'PARTY_SITES', 'HZ_PARTY_SITES',
'CONTACTS','HZ_ORG_CONTACTS',
'CONTACT_POINTS', 'HZ_CONTACT_POINTS')
and owner_table_id = p_record_id
and nvl(STATUS,'A')='A' )
LOOP
retstr := retstr || t_cur.orig_system ||' '|| t_cur.orig_system_reference || ' ';
select b.orig_system || ' '||a.orig_system_reference
into retstr
from hz_parties a, hz_orig_sys_references b
where b.owner_table_id = p_record_id
and b.owner_table_name = 'HZ_PARTIES'
and b.orig_system_reference = a.orig_system_reference
and nvl(b.STATUS,'A')='A';
select b.orig_system || ' '||a.orig_system_reference into retstr
from hz_party_sites a, hz_orig_sys_references b
where b.owner_table_id = p_record_id
and b.owner_table_name = 'HZ_PARTY_SITES'
and b.orig_system_reference = a.orig_system_reference
and nvl(b.STATUS,'A')='A';
select b.orig_system || ' '||a.orig_system_reference into retstr
from hz_org_contacts a, hz_orig_sys_references b
where b.owner_table_id = p_record_id
and b.owner_table_name = 'HZ_ORG_CONTACTS'
and b.orig_system_reference = a.orig_system_reference
and nvl(b.STATUS,'A')='A';
select b.orig_system || ' '||a.orig_system_reference into retstr
from hz_contact_points a, hz_orig_sys_references b
where b.owner_table_id = p_record_id
and b.owner_table_name = 'HZ_CONTACT_POINTS'
and b.orig_system_reference = a.orig_system_reference
and nvl(b.STATUS,'A')='A';