1. Tables and Views for Financials
  2. JV_JOINT_VENTURES_VL

JV_JOINT_VENTURES_VL

Details

  • Schema: FUSION

  • Object owner: JV

  • Object type: VIEW

Columns

Name

ROW_ID

JOINT_VENTURE_ID

JOINT_VENTURE_NAME

JOINT_VENTURE_DESCRIPTION

OBJECT_VERSION_NUMBER

JOINT_VENTURE_SHORT_NAME

JOINT_VENTURE_STATUS_CODE

RESPONSIBLE_USER_ID

APPROVED_FLAG

APPROVED_DATE

BUSINESS_UNIT_ID

COA_INSTANCE_NUMBER

AR_INVOICE_MINIMUM_AMOUNT

AP_INVOICE_MINIMUM_AMOUNT

AP_LIABILITY_ACCOUNT_CCID

SEGMENT1_FLAG

SEGMENT2_FLAG

SEGMENT3_FLAG

SEGMENT4_FLAG

SEGMENT5_FLAG

SEGMENT6_FLAG

SEGMENT7_FLAG

SEGMENT8_FLAG

SEGMENT9_FLAG

SEGMENT10_FLAG

SEGMENT11_FLAG

SEGMENT12_FLAG

SEGMENT13_FLAG

SEGMENT14_FLAG

SEGMENT15_FLAG

SEGMENT16_FLAG

SEGMENT17_FLAG

SEGMENT18_FLAG

SEGMENT19_FLAG

SEGMENT20_FLAG

SEGMENT21_FLAG

SEGMENT22_FLAG

SEGMENT23_FLAG

SEGMENT24_FLAG

SEGMENT25_FLAG

SEGMENT26_FLAG

SEGMENT27_FLAG

SEGMENT28_FLAG

SEGMENT29_FLAG

SEGMENT30_FLAG

DEFAULT_OWNERSHIP_PERCENT_NAME

INCEPTION_DATE

BILL_WHEN_PAID_FLAG

RECEIVABLE_ACCOUNT_CCID

CLASSIFICATION_CODE

DISTRIBUTABLE_ACCT_SET_ID

DISTRIBUTION_ONLY_ACCT_SET_ID

JIB_TEMPLATE_NAME

JIB_REPORT_OUTPUT_FORMAT_CODE

EMAIL_ADDRESS

EXCLUDE_JV_TRANSACTIONS_FLAG

PROJECT_SET_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

Query

SQL_Statement

SELECT

b.ROWID ROW_ID,

b.JOINT_VENTURE_ID,

t.JOINT_VENTURE_NAME,

t.JOINT_VENTURE_DESCRIPTION,

b.OBJECT_VERSION_NUMBER,

b.JOINT_VENTURE_SHORT_NAME,

b.JOINT_VENTURE_STATUS_CODE,

b.RESPONSIBLE_USER_ID,

b.APPROVED_FLAG,

b.APPROVED_DATE,

b.BUSINESS_UNIT_ID,

b.COA_INSTANCE_NUMBER,

b.AR_INVOICE_MINIMUM_AMOUNT,

b.AP_INVOICE_MINIMUM_AMOUNT,

b.AP_LIABILITY_ACCOUNT_CCID,

b.SEGMENT1_FLAG,

b.SEGMENT2_FLAG,

b.SEGMENT3_FLAG,

b.SEGMENT4_FLAG,

b.SEGMENT5_FLAG,

b.SEGMENT6_FLAG,

b.SEGMENT7_FLAG,

b.SEGMENT8_FLAG,

b.SEGMENT9_FLAG,

b.SEGMENT10_FLAG,

b.SEGMENT11_FLAG,

b.SEGMENT12_FLAG,

b.SEGMENT13_FLAG,

b.SEGMENT14_FLAG,

b.SEGMENT15_FLAG,

b.SEGMENT16_FLAG,

b.SEGMENT17_FLAG,

b.SEGMENT18_FLAG,

b.SEGMENT19_FLAG,

b.SEGMENT20_FLAG,

b.SEGMENT21_FLAG,

b.SEGMENT22_FLAG,

b.SEGMENT23_FLAG,

b.SEGMENT24_FLAG,

b.SEGMENT25_FLAG,

b.SEGMENT26_FLAG,

b.SEGMENT27_FLAG,

b.SEGMENT28_FLAG,

b.SEGMENT29_FLAG,

b.SEGMENT30_FLAG,

b.DEFAULT_OWNERSHIP_PERCENT_NAME,

b.INCEPTION_DATE,

b.BILL_WHEN_PAID_FLAG,

b.RECEIVABLE_ACCOUNT_CCID,

b.CLASSIFICATION_CODE,

b.DISTRIBUTABLE_ACCT_SET_ID,

b.DISTRIBUTION_ONLY_ACCT_SET_ID,

b.JIB_TEMPLATE_NAME,

b.JIB_REPORT_OUTPUT_FORMAT_CODE,

b.EMAIL_ADDRESS,

b.EXCLUDE_JV_TRANSACTIONS_FLAG,

b.PROJECT_SET_ID,

b.CREATED_BY,

b.CREATION_DATE,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATE_LOGIN,

b.ATTRIBUTE_CATEGORY,

b.ATTRIBUTE_CHAR1,

b.ATTRIBUTE_CHAR2,

b.ATTRIBUTE_CHAR3,

b.ATTRIBUTE_CHAR4,

b.ATTRIBUTE_CHAR5,

b.ATTRIBUTE_CHAR6,

b.ATTRIBUTE_CHAR7,

b.ATTRIBUTE_CHAR8,

b.ATTRIBUTE_CHAR9,

b.ATTRIBUTE_CHAR10,

b.ATTRIBUTE_NUMBER1,

b.ATTRIBUTE_NUMBER2,

b.ATTRIBUTE_NUMBER3,

b.ATTRIBUTE_NUMBER4,

b.ATTRIBUTE_NUMBER5,

b.ATTRIBUTE_DATE1,

b.ATTRIBUTE_DATE2,

b.ATTRIBUTE_DATE3,

b.ATTRIBUTE_DATE4,

b.ATTRIBUTE_DATE5

FROM

JV_JOINT_VENTURES_B b,

JV_JOINT_VENTURES_TL t

WHERE

b.JOINT_VENTURE_ID = t.JOINT_VENTURE_ID

AND t.LANGUAGE = USERENV('LANG')