[Home] [Help] [Dependency Information]
Object Name: | HZ_ORGANIZATION_BO |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
ACTION_TYPE | VARCHAR2 | (30) | |
COMMON_OBJ_ID | VARCHAR2 | (255) | |
ORGANIZATION_ID | NUMBER |
|
|
ORIG_SYSTEM | VARCHAR2 | (30) | |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (255) | |
PARTY_NUMBER | VARCHAR2 | (30) | |
VALIDATED_FLAG | VARCHAR2 | (1) | |
STATUS | VARCHAR2 | (1) | |
CATEGORY_CODE | VARCHAR2 | (30) | |
SALUTATION | VARCHAR2 | (60) | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | |
ATTRIBUTE1 | VARCHAR2 | (150) | |
ATTRIBUTE2 | VARCHAR2 | (150) | |
ATTRIBUTE3 | VARCHAR2 | (150) | |
ATTRIBUTE4 | VARCHAR2 | (150) | |
ATTRIBUTE5 | VARCHAR2 | (150) | |
ATTRIBUTE6 | VARCHAR2 | (150) | |
ATTRIBUTE7 | VARCHAR2 | (150) | |
ATTRIBUTE8 | VARCHAR2 | (150) | |
ATTRIBUTE9 | VARCHAR2 | (150) | |
ATTRIBUTE10 | VARCHAR2 | (150) | |
ATTRIBUTE11 | VARCHAR2 | (150) | |
ATTRIBUTE12 | VARCHAR2 | (150) | |
ATTRIBUTE13 | VARCHAR2 | (150) | |
ATTRIBUTE14 | VARCHAR2 | (150) | |
ATTRIBUTE15 | VARCHAR2 | (150) | |
ATTRIBUTE16 | VARCHAR2 | (150) | |
ATTRIBUTE17 | VARCHAR2 | (150) | |
ATTRIBUTE18 | VARCHAR2 | (150) | |
ATTRIBUTE19 | VARCHAR2 | (150) | |
ATTRIBUTE20 | VARCHAR2 | (150) | |
ATTRIBUTE21 | VARCHAR2 | (150) | |
ATTRIBUTE22 | VARCHAR2 | (150) | |
ATTRIBUTE23 | VARCHAR2 | (150) | |
ATTRIBUTE24 | VARCHAR2 | (150) | |
ORGANIZATION_NAME | VARCHAR2 | (360) | |
DUNS_NUMBER_C | VARCHAR2 | (30) | |
ENQUIRY_DUNS | VARCHAR2 | (15) | |
CEO_NAME | VARCHAR2 | (240) | |
CEO_TITLE | VARCHAR2 | (240) | |
PRINCIPAL_NAME | VARCHAR2 | (240) | |
PRINCIPAL_TITLE | VARCHAR2 | (240) | |
LEGAL_STATUS | VARCHAR2 | (30) | |
CONTROL_YR | NUMBER |
|
|
EMPLOYEES_TOTAL | NUMBER |
|
|
HQ_BRANCH_IND | VARCHAR2 | (30) | |
BRANCH_FLAG | VARCHAR2 | (1) | |
OOB_IND | VARCHAR2 | (30) | |
LINE_OF_BUSINESS | VARCHAR2 | (240) | |
CONG_DIST_CODE | VARCHAR2 | (2) | |
SIC_CODE | VARCHAR2 | (30) | |
IMPORT_IND | VARCHAR2 | (30) | |
EXPORT_IND | VARCHAR2 | (30) | |
LABOR_SURPLUS_IND | VARCHAR2 | (30) | |
DEBARMENT_IND | VARCHAR2 | (30) | |
MINORITY_OWNED_IND | VARCHAR2 | (30) | |
MINORITY_OWNED_TYPE | VARCHAR2 | (30) | |
WOMAN_OWNED_IND | VARCHAR2 | (30) | |
DISADV_8A_IND | VARCHAR2 | (30) | |
SMALL_BUS_IND | VARCHAR2 | (30) | |
RENT_OWN_IND | VARCHAR2 | (30) | |
DEBARMENTS_COUNT | NUMBER |
|
|
DEBARMENTS_DATE | DATE |
|
|
FAILURE_SCORE | VARCHAR2 | (30) | |
FAILURE_SCORE_NATNL_PER | NUMBER |
|
|
FAILURE_SCORE_OVERRIDE_CODE | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY | VARCHAR2 | (30) | |
GLOBAL_FAILURE_SCORE | VARCHAR2 | (5) | |
DB_RATING | VARCHAR2 | (5) | |
CREDIT_SCORE | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY | VARCHAR2 | (30) | |
PAYDEX_SCORE | VARCHAR2 | (3) | |
PAYDEX_THREE_MONTHS_AGO | VARCHAR2 | (3) | |
PAYDEX_NORM | VARCHAR2 | (3) | |
BEST_TIME_CONTACT_BEGIN | DATE |
|
|
BEST_TIME_CONTACT_END | DATE |
|
|
ORGANIZATION_NAME_PHONETIC | VARCHAR2 | (320) | |
TAX_REFERENCE | VARCHAR2 | (50) | |
GSA_INDICATOR_FLAG | VARCHAR2 | (1) | |
JGZZ_FISCAL_CODE | VARCHAR2 | (20) | |
ANALYSIS_FY | VARCHAR2 | (5) | |
FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | |
CURR_FY_POTENTIAL_REVENUE | NUMBER |
|
|
NEXT_FY_POTENTIAL_REVENUE | NUMBER |
|
|
YEAR_ESTABLISHED | NUMBER |
|
|
MISSION_STATEMENT | VARCHAR2 | (2000) | |
ORGANIZATION_TYPE | VARCHAR2 | (30) | |
BUSINESS_SCOPE | VARCHAR2 | (20) | |
CORPORATION_CLASS | VARCHAR2 | (60) | |
KNOWN_AS | VARCHAR2 | (240) | |
KNOWN_AS2 | VARCHAR2 | (240) | |
KNOWN_AS3 | VARCHAR2 | (240) | |
KNOWN_AS4 | VARCHAR2 | (240) | |
KNOWN_AS5 | VARCHAR2 | (240) | |
LOCAL_BUS_IDEN_TYPE | VARCHAR2 | (30) | |
LOCAL_BUS_IDENTIFIER | VARCHAR2 | (60) | |
PREF_FUNCTIONAL_CURRENCY | VARCHAR2 | (30) | |
REGISTRATION_TYPE | VARCHAR2 | (30) | |
TOTAL_EMPLOYEES_TEXT | VARCHAR2 | (60) | |
TOTAL_EMPLOYEES_IND | VARCHAR2 | (30) | |
TOTAL_EMP_EST_IND | VARCHAR2 | (30) | |
TOTAL_EMP_MIN_IND | VARCHAR2 | (30) | |
PARENT_SUB_IND | VARCHAR2 | (30) | |
INCORP_YEAR | NUMBER |
|
|
SIC_CODE_TYPE | VARCHAR2 | (30) | |
PUBLIC_PRIVATE_OWNER_FLAG | VARCHAR2 | (1) | |
INTERNAL_FLAG | VARCHAR2 | (30) | |
LOCAL_ACTIVITY_CODE_TYPE | VARCHAR2 | (30) | |
LOCAL_ACTIVITY_CODE | VARCHAR2 | (30) | |
EMP_AT_PRIMARY_ADR | VARCHAR2 | (10) | |
EMP_AT_PRIMARY_ADR_TEXT | VARCHAR2 | (12) | |
EMP_AT_PRIMARY_ADR_EST_IND | VARCHAR2 | (30) | |
EMP_AT_PRIMARY_ADR_MIN_IND | VARCHAR2 | (30) | |
HIGH_CREDIT | NUMBER |
|
|
AVG_HIGH_CREDIT | NUMBER |
|
|
TOTAL_PAYMENTS | NUMBER |
|
|
CREDIT_SCORE_CLASS | NUMBER |
|
|
CREDIT_SCORE_NATL_PERCENTILE | NUMBER |
|
|
CREDIT_SCORE_INCD_DEFAULT | NUMBER |
|
|
CREDIT_SCORE_AGE | NUMBER |
|
|
CREDIT_SCORE_DATE | DATE |
|
|
CREDIT_SCORE_COMMENTARY2 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY3 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY4 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY5 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY6 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY7 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY8 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY9 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY10 | VARCHAR2 | (30) | |
FAILURE_SCORE_CLASS | NUMBER |
|
|
FAILURE_SCORE_INCD_DEFAULT | NUMBER |
|
|
FAILURE_SCORE_AGE | NUMBER |
|
|
FAILURE_SCORE_DATE | DATE |
|
|
FAILURE_SCORE_COMMENTARY2 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY3 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY4 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY5 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY6 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY7 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY8 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY9 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY10 | VARCHAR2 | (30) | |
MAXIMUM_CREDIT_RECOMMEND | NUMBER |
|
|
MAXIMUM_CREDIT_CURRENCY_CODE | VARCHAR2 | (240) | |
DISPLAYED_DUNS_PARTY_ID | NUMBER |
|
|
PROGRAM_UPDATE_DATE | DATE |
|
|
CREATED_BY_MODULE | VARCHAR2 | (150) | |
CREATED_BY_NAME | VARCHAR2 | (100) | |
CREATION_DATE | DATE |
|
|
LAST_UPDATE_DATE | DATE |
|
|
LAST_UPDATED_BY_NAME | VARCHAR2 | (100) | |
DO_NOT_CONFUSE_WITH | VARCHAR2 | (255) | |
ACTUAL_CONTENT_SOURCE | VARCHAR2 | (30) | |
ORIG_SYS_OBJS | HZ_ORIG_SYS_REF_OBJ_TBL |
|
|
EXT_ATTRIBUTES_OBJS | HZ_EXT_ATTRIBUTE_OBJ_TBL |
|
|
CONTACT_OBJS | HZ_ORG_CONTACT_BO_TBL |
|
|
PARTY_SITE_OBJS | HZ_PARTY_SITE_BO_TBL |
|
|
PREFERENCE_OBJS | HZ_PARTY_PREF_OBJ_TBL |
|
|
PHONE_OBJS | HZ_PHONE_CP_BO_TBL |
|
|
TELEX_OBJS | HZ_TELEX_CP_BO_TBL |
|
|
EMAIL_OBJS | HZ_EMAIL_CP_BO_TBL |
|
|
WEB_OBJS | HZ_WEB_CP_BO_TBL |
|
|
EDI_OBJS | HZ_EDI_CP_BO_TBL |
|
|
EFT_OBJS | HZ_EFT_CP_BO_TBL |
|
|
RELATIONSHIP_OBJS | HZ_RELATIONSHIP_OBJ_TBL |
|
|
CLASS_OBJS | HZ_CODE_ASSIGNMENT_OBJ_TBL |
|
|
FINANCIAL_REPORT_OBJS | HZ_FINANCIAL_BO_TBL |
|
|
CREDIT_RATING_OBJS | HZ_CREDIT_RATING_OBJ_TBL |
|
|
CERTIFICATION_OBJS | HZ_CERTIFICATION_OBJ_TBL |
|
|
FINANCIAL_PROF_OBJS | HZ_FINANCIAL_PROF_OBJ_TBL |
|
|
CONTACT_PREF_OBJS | HZ_CONTACT_PREF_OBJ_TBL |
|
|
PARTY_USAGE_OBJS | HZ_PARTY_USAGE_OBJ_TBL |
|
Name | Parameters | Result |
---|---|---|
CREATE_OBJECT |
P_ORGANIZATION_ID(NUMBER) P_ORIG_SYSTEM(VARCHAR2) P_ORIG_SYSTEM_REFERENCE(VARCHAR2) P_PARTY_NUMBER(VARCHAR2) P_VALIDATED_FLAG(VARCHAR2) P_STATUS(VARCHAR2) P_CATEGORY_CODE(VARCHAR2) P_SALUTATION(VARCHAR2) P_ATTRIBUTE_CATEGORY(VARCHAR2) P_ATTRIBUTE1(VARCHAR2) P_ATTRIBUTE2(VARCHAR2) P_ATTRIBUTE3(VARCHAR2) P_ATTRIBUTE4(VARCHAR2) P_ATTRIBUTE5(VARCHAR2) P_ATTRIBUTE6(VARCHAR2) P_ATTRIBUTE7(VARCHAR2) P_ATTRIBUTE8(VARCHAR2) P_ATTRIBUTE9(VARCHAR2) P_ATTRIBUTE10(VARCHAR2) P_ATTRIBUTE11(VARCHAR2) P_ATTRIBUTE12(VARCHAR2) P_ATTRIBUTE13(VARCHAR2) P_ATTRIBUTE14(VARCHAR2) P_ATTRIBUTE15(VARCHAR2) P_ATTRIBUTE16(VARCHAR2) P_ATTRIBUTE17(VARCHAR2) P_ATTRIBUTE18(VARCHAR2) P_ATTRIBUTE19(VARCHAR2) P_ATTRIBUTE20(VARCHAR2) P_ATTRIBUTE21(VARCHAR2) P_ATTRIBUTE22(VARCHAR2) P_ATTRIBUTE23(VARCHAR2) P_ATTRIBUTE24(VARCHAR2) P_ORGANIZATION_NAME(VARCHAR2) P_DUNS_NUMBER_C(VARCHAR2) P_ENQUIRY_DUNS(VARCHAR2) P_CEO_NAME(VARCHAR2) P_CEO_TITLE(VARCHAR2) P_PRINCIPAL_NAME(VARCHAR2) P_PRINCIPAL_TITLE(VARCHAR2) P_LEGAL_STATUS(VARCHAR2) P_CONTROL_YR(NUMBER) P_EMPLOYEES_TOTAL(NUMBER) P_HQ_BRANCH_IND(VARCHAR2) P_BRANCH_FLAG(VARCHAR2) P_OOB_IND(VARCHAR2) P_LINE_OF_BUSINESS(VARCHAR2) P_CONG_DIST_CODE(VARCHAR2) P_SIC_CODE(VARCHAR2) P_IMPORT_IND(VARCHAR2) P_EXPORT_IND(VARCHAR2) P_LABOR_SURPLUS_IND(VARCHAR2) P_DEBARMENT_IND(VARCHAR2) P_MINORITY_OWNED_IND(VARCHAR2) P_MINORITY_OWNED_TYPE(VARCHAR2) P_WOMAN_OWNED_IND(VARCHAR2) P_DISADV_8A_IND(VARCHAR2) P_SMALL_BUS_IND(VARCHAR2) P_RENT_OWN_IND(VARCHAR2) P_DEBARMENTS_COUNT(NUMBER) P_DEBARMENTS_DATE(DATE) P_FAILURE_SCORE(VARCHAR2) P_FAILURE_SCORE_NATNL_PER(NUMBER) P_FAILURE_SCORE_OVERRIDE_CODE(VARCHAR2) P_FAILURE_SCORE_COMMENTARY(VARCHAR2) P_GLOBAL_FAILURE_SCORE(VARCHAR2) P_DB_RATING(VARCHAR2) P_CREDIT_SCORE(VARCHAR2) P_CREDIT_SCORE_COMMENTARY(VARCHAR2) P_PAYDEX_SCORE(VARCHAR2) P_PAYDEX_THREE_MONTHS_AGO(VARCHAR2) P_PAYDEX_NORM(VARCHAR2) P_BEST_TIME_CONTACT_BEGIN(DATE) P_BEST_TIME_CONTACT_END(DATE) P_ORGANIZATION_NAME_PHONETIC(VARCHAR2) P_TAX_REFERENCE(VARCHAR2) P_GSA_INDICATOR_FLAG(VARCHAR2) P_JGZZ_FISCAL_CODE(VARCHAR2) P_ANALYSIS_FY(VARCHAR2) P_FISCAL_YEAREND_MONTH(VARCHAR2) P_CURR_FY_POTENTIAL_REVENUE(NUMBER) P_NEXT_FY_POTENTIAL_REVENUE(NUMBER) P_YEAR_ESTABLISHED(NUMBER) P_MISSION_STATEMENT(VARCHAR2) P_ORGANIZATION_TYPE(VARCHAR2) P_BUSINESS_SCOPE(VARCHAR2) P_CORPORATION_CLASS(VARCHAR2) P_KNOWN_AS(VARCHAR2) P_KNOWN_AS2(VARCHAR2) P_KNOWN_AS3(VARCHAR2) P_KNOWN_AS4(VARCHAR2) P_KNOWN_AS5(VARCHAR2) P_LOCAL_BUS_IDEN_TYPE(VARCHAR2) P_LOCAL_BUS_IDENTIFIER(VARCHAR2) P_PREF_FUNCTIONAL_CURRENCY(VARCHAR2) P_REGISTRATION_TYPE(VARCHAR2) P_TOTAL_EMPLOYEES_TEXT(VARCHAR2) P_TOTAL_EMPLOYEES_IND(VARCHAR2) P_TOTAL_EMP_EST_IND(VARCHAR2) P_TOTAL_EMP_MIN_IND(VARCHAR2) P_PARENT_SUB_IND(VARCHAR2) P_INCORP_YEAR(NUMBER) P_SIC_CODE_TYPE(VARCHAR2) P_PUBLIC_PRIVATE_OWNER_FLAG(VARCHAR2) P_INTERNAL_FLAG(VARCHAR2) P_LOCAL_ACTIVITY_CODE_TYPE(VARCHAR2) P_LOCAL_ACTIVITY_CODE(VARCHAR2) P_EMP_AT_PRIMARY_ADR(VARCHAR2) P_EMP_AT_PRIMARY_ADR_TEXT(VARCHAR2) P_EMP_AT_PRIMARY_ADR_EST_IND(VARCHAR2) P_EMP_AT_PRIMARY_ADR_MIN_IND(VARCHAR2) P_HIGH_CREDIT(NUMBER) P_AVG_HIGH_CREDIT(NUMBER) P_TOTAL_PAYMENTS(NUMBER) P_CREDIT_SCORE_CLASS(NUMBER) P_CREDIT_SCORE_NATL_PERCENTILE(NUMBER) P_CREDIT_SCORE_INCD_DEFAULT(NUMBER) P_CREDIT_SCORE_AGE(NUMBER) P_CREDIT_SCORE_DATE(DATE) P_CREDIT_SCORE_COMMENTARY2(VARCHAR2) P_CREDIT_SCORE_COMMENTARY3(VARCHAR2) P_CREDIT_SCORE_COMMENTARY4(VARCHAR2) P_CREDIT_SCORE_COMMENTARY5(VARCHAR2) P_CREDIT_SCORE_COMMENTARY6(VARCHAR2) P_CREDIT_SCORE_COMMENTARY7(VARCHAR2) P_CREDIT_SCORE_COMMENTARY8(VARCHAR2) P_CREDIT_SCORE_COMMENTARY9(VARCHAR2) P_CREDIT_SCORE_COMMENTARY10(VARCHAR2) P_FAILURE_SCORE_CLASS(NUMBER) P_FAILURE_SCORE_INCD_DEFAULT(NUMBER) P_FAILURE_SCORE_AGE(NUMBER) P_FAILURE_SCORE_DATE(DATE) P_FAILURE_SCORE_COMMENTARY2(VARCHAR2) P_FAILURE_SCORE_COMMENTARY3(VARCHAR2) P_FAILURE_SCORE_COMMENTARY4(VARCHAR2) P_FAILURE_SCORE_COMMENTARY5(VARCHAR2) P_FAILURE_SCORE_COMMENTARY6(VARCHAR2) P_FAILURE_SCORE_COMMENTARY7(VARCHAR2) P_FAILURE_SCORE_COMMENTARY8(VARCHAR2) P_FAILURE_SCORE_COMMENTARY9(VARCHAR2) P_FAILURE_SCORE_COMMENTARY10(VARCHAR2) P_MAXIMUM_CREDIT_RECOMMEND(NUMBER) P_MAXIMUM_CREDIT_CURRENCY_CODE(VARCHAR2) P_DISPLAYED_DUNS_PARTY_ID(NUMBER) P_ACTUAL_CONTENT_SOURCE(VARCHAR2) P_DO_NOT_CONFUSE_WITH(VARCHAR2) |
HZ_ORGANIZATION_BO |
|
|
|