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.

DBA Data [Home] [Help] [Dependency Information]

TYPE: APPS.POS_ORGANIZATION_BO

Object Details

Object Name:	POS_ORGANIZATION_BO
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
ACTION_TYPE_P	VARCHAR2	(30)
COMMON_OBJ_ID_P	VARCHAR2	(255)
ORGANIZATION_ID_P	NUMBER
ORIG_SYSTEM_P	VARCHAR2	(30)
ORIG_SYSTEM_REFERENCE_P	VARCHAR2	(255)
PARTY_NUMBER_P	VARCHAR2	(30)
VALIDATED_FLAG_P	VARCHAR2	(1)
STATUS_P	VARCHAR2	(1)
CATEGORY_CODE_P	VARCHAR2	(30)
SALUTATION_P	VARCHAR2	(60)
ATTRIBUTE_CATEGORY_P	VARCHAR2	(30)
ATTRIBUTE1_P	VARCHAR2	(150)
ATTRIBUTE2_P	VARCHAR2	(150)
ATTRIBUTE3_P	VARCHAR2	(150)
ATTRIBUTE4_P	VARCHAR2	(150)
ATTRIBUTE5_P	VARCHAR2	(150)
ATTRIBUTE6_P	VARCHAR2	(150)
ATTRIBUTE7_P	VARCHAR2	(150)
ATTRIBUTE8_P	VARCHAR2	(150)
ATTRIBUTE9_P	VARCHAR2	(150)
ATTRIBUTE10_P	VARCHAR2	(150)
ATTRIBUTE11_P	VARCHAR2	(150)
ATTRIBUTE12_P	VARCHAR2	(150)
ATTRIBUTE13_P	VARCHAR2	(150)
ATTRIBUTE14_P	VARCHAR2	(150)
ATTRIBUTE15_P	VARCHAR2	(150)
ATTRIBUTE16_P	VARCHAR2	(150)
ATTRIBUTE17_P	VARCHAR2	(150)
ATTRIBUTE18_P	VARCHAR2	(150)
ATTRIBUTE19_P	VARCHAR2	(150)
ATTRIBUTE20_P	VARCHAR2	(150)
ATTRIBUTE21_P	VARCHAR2	(150)
ATTRIBUTE22_P	VARCHAR2	(150)
ATTRIBUTE23_P	VARCHAR2	(150)
ATTRIBUTE24_P	VARCHAR2	(150)
ORGANIZATION_NAME_P	VARCHAR2	(360)
DUNS_NUMBER_P	VARCHAR2	(30)
ENQUIRY_DUNS_P	VARCHAR2	(15)
CEO_NAME_P	VARCHAR2	(240)
CEO_TITLE_P	VARCHAR2	(240)
PRINCIPAL_NAME_P	VARCHAR2	(240)
PRINCIPAL_TITLE_P	VARCHAR2	(240)
LEGAL_STATUS_P	VARCHAR2	(30)
CONTROL_YR_P	NUMBER
EMPLOYEES_TOTAL_P	NUMBER
HQ_BRANCH_IND_P	VARCHAR2	(30)
BRANCH_FLAG_P	VARCHAR2	(1)
OOB_IND_P	VARCHAR2	(30)
LINE_OF_BUSINESS_P	VARCHAR2	(240)
CONG_DIST_CODE_P	VARCHAR2	(2)
SIC_CODE_P	VARCHAR2	(30)
IMPORT_IND_P	VARCHAR2	(30)
EXPORT_IND_P	VARCHAR2	(30)
LABOR_SURPLUS_IND_P	VARCHAR2	(30)
DEBARMENT_IND_P	VARCHAR2	(30)
MINORITY_OWNED_IND_P	VARCHAR2	(30)
MINORITY_OWNED_TYPE_P	VARCHAR2	(30)
WOMAN_OWNED_IND_P	VARCHAR2	(30)
DISADV_8A_IND_P	VARCHAR2	(30)
SMALL_BUS_IND_P	VARCHAR2	(30)
RENT_OWN_IND_P	VARCHAR2	(30)
DEBARMENTS_COUNT_P	NUMBER
DEBARMENTS_DATE_P	DATE
FAILURE_SCORE_P	VARCHAR2	(30)
FAILURE_SCORE_NATNL_PER_P	NUMBER
FAILURE_SCORE_OVERRIDE_CODE_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY_P	VARCHAR2	(30)
GLOBAL_FAILURE_SCORE_P	VARCHAR2	(5)
DB_RATING_P	VARCHAR2	(5)
CREDIT_SCORE_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY_P	VARCHAR2	(30)
PAYDEX_SCORE_P	VARCHAR2	(3)
PAYDEX_THREE_MONTHS_AGO_P	VARCHAR2	(3)
PAYDEX_NORM_P	VARCHAR2	(3)
BEST_TIME_CONTACT_BEGIN_P	DATE
BEST_TIME_CONTACT_END_P	DATE
ORGANIZATION_NAME_PHONETIC_P	VARCHAR2	(320)
TAX_REFERENCE_P	VARCHAR2	(50)
GSA_INDICATOR_FLAG_P	VARCHAR2	(1)
JGZZ_FISCAL_CODE_P	VARCHAR2	(20)
ANALYSIS_FY_P	VARCHAR2	(5)
FISCAL_YEAREND_MONTH_P	VARCHAR2	(30)
CURR_FY_POTENTIAL_REVENUE_P	NUMBER
NEXT_FY_POTENTIAL_REVENUE_P	NUMBER
YEAR_ESTABLISHED_P	NUMBER
MISSION_STATEMENT_P	VARCHAR2	(2000)
ORGANIZATION_TYPE_P	VARCHAR2	(30)
BUSINESS_SCOPE_P	VARCHAR2	(20)
CORPORATION_CLASS_P	VARCHAR2	(60)
KNOWN_AS_P	VARCHAR2	(240)
KNOWN_AS2_P	VARCHAR2	(240)
KNOWN_AS3_P	VARCHAR2	(240)
KNOWN_AS4_P	VARCHAR2	(240)
KNOWN_AS5_P	VARCHAR2	(240)
LOCAL_BUS_IDEN_TYPE_P	VARCHAR2	(30)
LOCAL_BUS_IDENTIFIER_P	VARCHAR2	(60)
PREF_FUNCTIONAL_CURRENCY_P	VARCHAR2	(30)
REGISTRATION_TYPE_P	VARCHAR2	(30)
TOTAL_EMPLOYEES_TEXT_P	VARCHAR2	(60)
TOTAL_EMPLOYEES_IND_P	VARCHAR2	(30)
TOTAL_EMP_EST_IND_P	VARCHAR2	(30)
TOTAL_EMP_MIN_IND_P	VARCHAR2	(30)
PARENT_SUB_IND_P	VARCHAR2	(30)
INCORP_YEAR_P	NUMBER
SIC_CODE_TYPE_P	VARCHAR2	(30)
PUBLIC_PRIVATE_OWNER_FLAG_P	VARCHAR2	(1)
INTERNAL_FLAG_P	VARCHAR2	(30)
LOCAL_ACTIVITY_CODE_TYPE_P	VARCHAR2	(30)
LOCAL_ACTIVITY_CODE_P	VARCHAR2	(30)
EMP_AT_PRIMARY_ADR_P	VARCHAR2	(10)
EMP_AT_PRIMARY_ADR_TEXT_P	VARCHAR2	(12)
EMP_AT_PRIMARY_ADR_EST_IND_P	VARCHAR2	(30)
EMP_AT_PRIMARY_ADR_MIN_IND_P	VARCHAR2	(30)
HIGH_CREDIT_P	NUMBER
AVG_HIGH_CREDIT_P	NUMBER
TOTAL_PAYMENTS_P	NUMBER
CREDIT_SCORE_CLASS_P	NUMBER
CREDIT_SCORE_NATL_PERCENTILE_P	NUMBER
CREDIT_SCORE_INCD_DEFAULT_P	NUMBER
CREDIT_SCORE_AGE_P	NUMBER
CREDIT_SCORE_DATE_P	DATE
CREDIT_SCORE_COMMENTARY2_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY3_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY4_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY5_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY6_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY7_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY8_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY9_P	VARCHAR2	(30)
CREDIT_SCORE_COMMENTARY10_P	VARCHAR2	(30)
FAILURE_SCORE_CLASS_P	NUMBER
FAILURE_SCORE_INCD_DEFAULT_P	NUMBER
FAILURE_SCORE_AGE_P	NUMBER
FAILURE_SCORE_DATE_P	DATE
FAILURE_SCORE_COMMENTARY2_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY3_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY4_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY5_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY6_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY7_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY8_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY9_P	VARCHAR2	(30)
FAILURE_SCORE_COMMENTARY10_P	VARCHAR2	(30)
MAXIMUM_CREDIT_RECOMMEND_P	NUMBER
MAXIMUM_CREDIT_CURRENCY_CODE_P	VARCHAR2	(240)
DISPLAYED_DUNS_PARTY_ID_P	NUMBER
PROGRAM_UPDATE_DATE_P	DATE
CREATED_BY_MODULE_P	VARCHAR2	(150)
CREATED_BY_NAME_P	VARCHAR2	(100)
CREATION_DATE_P	DATE
LAST_UPDATE_DATE_P	DATE
LAST_UPDATED_BY_NAME_P	VARCHAR2	(100)
DO_NOT_CONFUSE_WITH_P	VARCHAR2	(255)
ACTUAL_CONTENT_SOURCE_P	VARCHAR2	(30)
ORIG_SYS_OBJS	HZ_ORIG_SYS_REF_OBJ_TBL
EXT_ATTRIBUTES_OBJS	HZ_EXT_ATTRIBUTE_OBJ_TBL
CONTACT_OBJS	POS_ORG_CONTACT_BO_TBL
PARTY_SITE_OBJS	POS_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

Dependencies

[top of page]

APPS.POS_ORGANIZATION_BO references the following:

APPS: HZ_CERTIFICATION_OBJ_TBL; HZ_CODE_ASSIGNMENT_OBJ_TBL; HZ_CONTACT_PREF_OBJ_TBL; HZ_CREDIT_RATING_OBJ_TBL; HZ_EDI_CP_BO_TBL; HZ_EFT_CP_BO_TBL; HZ_EMAIL_CP_BO_TBL; HZ_EXT_ATTRIBUTE_OBJ_TBL; HZ_FINANCIAL_BO_TBL; HZ_FINANCIAL_PROF_OBJ_TBL; HZ_ORIG_SYS_REF_OBJ_TBL; HZ_PARTY_PREF_OBJ_TBL; HZ_PARTY_USAGE_OBJ_TBL; HZ_PHONE_CP_BO_TBL; HZ_RELATIONSHIP_OBJ_TBL; HZ_TELEX_CP_BO_TBL; HZ_WEB_CP_BO_TBL; POS_ORG_CONTACT_BO_TBL; POS_PARTY_SITE_BO_TBL
SYS: STANDARD - show dependent code

APPS.POS_ORGANIZATION_BO is referenced by following:

APPS: POS_SUPPLIER_BO; POS_SUPPLIER_BO_PKG - show dependent code