JV_JOINT_VENTURES_B

This table contains the joint venture definitions.

Details

  • Schema: FUSION

  • Object owner: JV

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

JV_JOINT_VENTURES_B_PK

JOINT_VENTURE_ID

Columns

Name Datatype Length Precision Not-null Comments
JOINT_VENTURE_ID NUMBER 18 Yes Unique identifier for the joint venture.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
JOINT_VENTURE_SHORT_NAME VARCHAR2 30 Yes The unique code representing the short name of the joint venture.
JOINT_VENTURE_STATUS_CODE VARCHAR2 30 Yes The status code of the joint venture. It is based on ORA_JV_JOINT_VENTURE_STATUS lookup codes such as ORA_JV_ACTIVE, ORA_JV_INITIATED, or other user defined values.
RESPONSIBLE_USER_ID NUMBER 18 The person responsible for the joint venture.
APPROVED_FLAG VARCHAR2 1 Yes Indicates whether the joint venture has been approved by the stakeholders.
APPROVED_DATE DATE The date the joint venture was approved.
BUSINESS_UNIT_ID NUMBER 18 Unique ID of the business unit associated with the joint venture.
COA_INSTANCE_NUMBER NUMBER 18 Links the chart of accounts structure instance number to the joint venture to identify which account segment contains the cost center. This value is validated against the FND_KF_STR_INSTANCES_B table.
AR_INVOICE_MINIMUM_AMOUNT NUMBER Yes The minimum amount required to create an accounts receivable invoice.
AP_INVOICE_MINIMUM_AMOUNT NUMBER Yes The minimum amount required to create a payables invoice.
AP_LIABILITY_ACCOUNT_CCID NUMBER 18 The account combination identifier for the default liability account used when creating a payables invoice.
SEGMENT1_FLAG VARCHAR2 1 Yes Indicates whether segment 1 is allowed to have distributable values associated with it.
SEGMENT2_FLAG VARCHAR2 1 Yes Indicates whether segment 2 is allowed to have distributable values associated with it.
SEGMENT3_FLAG VARCHAR2 1 Yes Indicates whether segment 3 is allowed to have distributable values associated with it.
SEGMENT4_FLAG VARCHAR2 1 Yes Indicates whether segment 4 is allowed to have distributable values associated with it.
SEGMENT5_FLAG VARCHAR2 1 Yes Indicates whether segment 5 is allowed to have distributable values associated with it.
SEGMENT6_FLAG VARCHAR2 1 Yes Indicates whether segment 6 is allowed to have distributable values associated with it.
SEGMENT7_FLAG VARCHAR2 1 Yes Indicates whether segment 7 is allowed to have distributable values associated with it.
SEGMENT8_FLAG VARCHAR2 1 Yes Indicates whether segment 8 is allowed to have distributable values associated with it.
SEGMENT9_FLAG VARCHAR2 1 Yes Indicates whether segment 9 is allowed to have distributable values associated with it.
SEGMENT10_FLAG VARCHAR2 1 Yes Indicates whether segment 10 is allowed to have distributable values associated with it.
SEGMENT11_FLAG VARCHAR2 1 Yes Indicates whether segment 11 is allowed to have distributable values associated with it.
SEGMENT12_FLAG VARCHAR2 1 Yes Indicates whether segment 12 is allowed to have distributable values associated with it.
SEGMENT13_FLAG VARCHAR2 1 Yes Indicates whether segment 13 is allowed to have distributable values associated with it.
SEGMENT14_FLAG VARCHAR2 1 Yes Indicates whether segment 14 is allowed to have distributable values associated with it.
SEGMENT15_FLAG VARCHAR2 1 Yes Indicates whether segment 15 is allowed to have distributable values associated with it.
SEGMENT16_FLAG VARCHAR2 1 Yes Indicates whether segment 16 is allowed to have distributable values associated with it.
SEGMENT17_FLAG VARCHAR2 1 Yes Indicates whether segment 17 is allowed to have distributable values associated with it.
SEGMENT18_FLAG VARCHAR2 1 Yes Indicates whether segment 18 is allowed to have distributable values associated with it.
SEGMENT19_FLAG VARCHAR2 1 Yes Indicates whether segment 19 is allowed to have distributable values associated with it.
SEGMENT20_FLAG VARCHAR2 1 Yes Indicates whether segment 20 is allowed to have distributable values associated with it.
SEGMENT21_FLAG VARCHAR2 1 Yes Indicates whether segment 21 is allowed to have distributable values associated with it.
SEGMENT22_FLAG VARCHAR2 1 Yes Indicates whether segment 22 is allowed to have distributable values associated with it.
SEGMENT23_FLAG VARCHAR2 1 Yes Indicates whether segment 23 is allowed to have distributable values associated with it.
SEGMENT24_FLAG VARCHAR2 1 Yes Indicates whether segment 24 is allowed to have distributable values associated with it.
SEGMENT25_FLAG VARCHAR2 1 Yes Indicates whether segment 25 is allowed to have distributable values associated with it.
SEGMENT26_FLAG VARCHAR2 1 Yes Indicates whether segment 26 is allowed to have distributable values associated with it.
SEGMENT27_FLAG VARCHAR2 1 Yes Indicates whether segment 27 is allowed to have distributable values associated with it.
SEGMENT28_FLAG VARCHAR2 1 Yes Indicates whether segment 28 is allowed to have distributable values associated with it.
SEGMENT29_FLAG VARCHAR2 1 Yes Indicates whether segment 29 is allowed to have distributable values associated with it.
SEGMENT30_FLAG VARCHAR2 1 Yes Indicates whether segment 30 is allowed to have distributable values associated with it.
DEFAULT_OWNERSHIP_PERCENT_NAME VARCHAR2 30 Name of the default ownership percentage associated with the joint venture that will be used to identify the stakeholders and their share of the transaction.
INCEPTION_DATE DATE The date that the joint venture became active and eligible for processing.
BILL_WHEN_PAID_FLAG VARCHAR2 1 Yes Determines whether joint venture distributions are created for paid expenses or costs.
RECEIVABLE_ACCOUNT_CCID NUMBER 18 Account combination identifier for the default receivable account used when creating a receivables invoice.
CLASSIFICATION_CODE VARCHAR2 30 Yes Indicates the classification of a joint venture as operated or non-operated.
DISTRIBUTABLE_ACCT_SET_ID NUMBER 18 Unique identifier of the account set used by the joint venture to identify distributable accounts.
DISTRIBUTION_ONLY_ACCT_SET_ID NUMBER 18 Unique identifier of the distribution only account set used by the joint venture to identify accounts whose transactions will be distributed and not invoiced.
JIB_TEMPLATE_NAME VARCHAR2 100 The name of the Joint Interest Billing report template associated with the joint venture.
JIB_REPORT_OUTPUT_FORMAT_CODE VARCHAR2 30 The format of the Joint Interest Billing report output associated with the joint venture. It's based on ORA_JV_JIB_OUTPUT_FORMAT lookup codes such as ORA_JV_HTML, ORA_JV_PDF, ORA_JV_RTF, and so on.
EMAIL_ADDRESS VARCHAR2 100 The email address of the managing partner.
EXCLUDE_JV_TRANSACTIONS_FLAG VARCHAR2 1 Yes Determines whether the Identify Joint Venture Transactions process will include invoices and journal entries created by joint venture processes.
PROJECT_SET_ID NUMBER 18 Unique identifier of the project set associated with the joint venture.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
JV_JOINT_VENTURES_B jv_account_sets_b DISTRIBUTABLE_ACCT_SET_ID
JV_JOINT_VENTURES_B jv_account_sets_b DISTRIBUTION_ONLY_ACCT_SET_ID
JV_JOINT_VENTURES_B jv_project_sets_b PROJECT_SET_ID
jv_generated_transactions jv_joint_ventures_b JOINT_VENTURE_ID
jv_transactions jv_joint_ventures_b JOINT_VENTURE_ID
jv_accounting_headers jv_joint_ventures_b JOINT_VENTURE_ID
jv_ci_agreements_b jv_joint_ventures_b JOINT_VENTURE_ID
jv_advance_payments_b jv_joint_ventures_b JOINT_VENTURE_ID
jv_distributions jv_joint_ventures_b JOINT_VENTURE_ID
jv_operational_states jv_joint_ventures_b JOINT_VENTURE_ID
jv_project_sets_b jv_joint_ventures_b JOINT_VENTURE_ID
jv_overhead_methods_f_b jv_joint_ventures_b JOINT_VENTURE_ID
jv_distributable_values jv_joint_ventures_b JOINT_VENTURE_ID
jv_joint_ventures_tl jv_joint_ventures_b JOINT_VENTURE_ID
jv_stakeholders_b jv_joint_ventures_b JOINT_VENTURE_ID
jv_operational_measures jv_joint_ventures_b JOINT_VENTURE_ID
jv_contribution_requests_b jv_joint_ventures_b JOINT_VENTURE_ID
jv_owner_percents_f_b jv_joint_ventures_b JOINT_VENTURE_ID
jv_cost_centers jv_joint_ventures_b JOINT_VENTURE_ID

Indexes

Index Uniqueness Tablespace Columns
JV_JOINT_VENTURES_B_PK Unique Default JOINT_VENTURE_ID
JV_JOINT_VENTURES_B_U1 Unique Default JOINT_VENTURE_SHORT_NAME