[Home] [Help] [Dependency Information]
Object Name: | ZX_REC_NREC_DIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.ZX_REC_NREC_DIST_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
REC_NREC_TAX_DIST_ID | NUMBER | (15) | Yes | |
APPLICATION_ID | NUMBER | Yes | ||
ENTITY_CODE | VARCHAR2 | (30) | Yes | |
EVENT_CLASS_CODE | VARCHAR2 | (30) | Yes | |
EVENT_TYPE_CODE | VARCHAR2 | (30) | Yes | |
TRX_ID | NUMBER | Yes | ||
TRX_NUMBER | VARCHAR2 | (150) | ||
TRX_LINE_ID | NUMBER | Yes | ||
TRX_LINE_NUMBER | NUMBER | |||
TAX_LINE_ID | NUMBER | (15) | Yes | |
TAX_LINE_NUMBER | NUMBER | Yes | ||
TRX_LINE_DIST_ID | NUMBER | Yes | ||
TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
ITEM_DIST_NUMBER | NUMBER | |||
REC_NREC_TAX_DIST_NUMBER | NUMBER | Yes | ||
REC_NREC_RATE | NUMBER | Yes | ||
RECOVERABLE_FLAG | VARCHAR2 | (1) | Yes | |
REC_NREC_TAX_AMT | NUMBER | Yes | ||
TAX_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
TAX_EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
CONTENT_OWNER_ID | NUMBER | (15) | ||
TAX_REGIME_ID | NUMBER | (15) | ||
TAX_REGIME_CODE | VARCHAR2 | (30) | ||
TAX_REGIME_NAME | VARCHAR2 | (80) | ||
TAX_ID | NUMBER | (15) | ||
TAX | VARCHAR2 | (30) | ||
TAX_FULL_NAME | VARCHAR2 | (80) | ||
TAX_STATUS_ID | NUMBER | (15) | ||
TAX_STATUS_CODE | VARCHAR2 | (30) | ||
TAX_STATUS_NAME | VARCHAR2 | (80) | ||
TAX_RATE_ID | NUMBER | (15) | ||
TAX_RATE_CODE | VARCHAR2 | (150) | ||
TAX_RATE_NAME | VARCHAR2 | (240) | ||
TAX_RATE | NUMBER | |||
INCLUSIVE_FLAG | VARCHAR2 | (1) | ||
RECOVERY_TYPE_ID | NUMBER | (15) | ||
RECOVERY_TYPE_CODE | VARCHAR2 | (30) | ||
RECOVERY_RATE_ID | NUMBER | (15) | ||
RECOVERY_RATE_CODE | VARCHAR2 | (150) | ||
REC_TYPE_RULE_FLAG | VARCHAR2 | (1) | ||
NEW_REC_RATE_CODE_FLAG | VARCHAR2 | (1) | ||
REVERSE_FLAG | VARCHAR2 | (1) | ||
HISTORICAL_FLAG | VARCHAR2 | (1) | ||
REVERSED_TAX_DIST_ID | NUMBER | |||
REC_NREC_TAX_AMT_TAX_CURR | NUMBER | |||
REC_NREC_TAX_AMT_FUNCL_CURR | NUMBER | |||
INTENDED_USE | VARCHAR2 | (30) | ||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
AWARD_ID | NUMBER | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
EXPENDITURE_ITEM_DATE | DATE | |||
REC_RATE_DET_RULE_FLAG | VARCHAR2 | (1) | ||
LEDGER_ID | NUMBER | (15) | ||
SUMMARY_TAX_LINE_ID | NUMBER | (15) | ||
RECORD_TYPE_CODE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
TAX_CURRENCY_CONVERSION_DATE | DATE | |||
TAX_CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
TAX_CURRENCY_CONVERSION_RATE | NUMBER | |||
TRX_CURRENCY_CODE | VARCHAR2 | (15) | ||
TAX_CURRENCY_CODE | VARCHAR2 | (15) | ||
TRX_LINE_DIST_QTY | NUMBER | |||
REF_DOC_TRX_LINE_DIST_QTY | NUMBER | |||
PRICE_DIFF | NUMBER | |||
QTY_DIFF | NUMBER | |||
PER_TRX_CURR_UNIT_NR_AMT | NUMBER | |||
REF_PER_TRX_CURR_UNIT_NR_AMT | NUMBER | |||
REF_DOC_CURR_CONV_RATE | NUMBER | |||
UNIT_PRICE | NUMBER | |||
REF_DOC_UNIT_PRICE | NUMBER | |||
PER_UNIT_NREC_TAX_AMT | NUMBER | |||
REF_DOC_PER_UNIT_NREC_TAX_AMT | NUMBER | |||
RATE_TAX_FACTOR | NUMBER | |||
TAX_APPORTIONMENT_FLAG | VARCHAR2 | (1) | ||
TRX_LINE_DIST_AMT | NUMBER | |||
TRX_LINE_DIST_TAX_AMT | NUMBER | |||
ORIG_REC_NREC_RATE | NUMBER | |||
ORIG_REC_RATE_CODE | VARCHAR2 | (150) | ||
ORIG_REC_NREC_TAX_AMT | NUMBER | |||
ORIG_REC_NREC_TAX_AMT_TAX_CURR | NUMBER | |||
ACCOUNT_CCID | NUMBER | |||
ACCOUNT_STRING | VARCHAR2 | (2000) | ||
UNROUNDED_REC_NREC_TAX_AMT | NUMBER | |||
APPLICABILITY_RESULT_ID | NUMBER | (15) | ||
REC_RATE_RESULT_ID | NUMBER | (15) | ||
BACKWARD_COMPATIBILITY_FLAG | VARCHAR2 | (1) | ||
OVERRIDDEN_FLAG | VARCHAR2 | (1) | ||
SELF_ASSESSED_FLAG | VARCHAR2 | (1) | ||
FREEZE_FLAG | VARCHAR2 | (1) | ||
POSTING_FLAG | VARCHAR2 | (1) | ||
GL_DATE | DATE | |||
REF_DOC_APPLICATION_ID | NUMBER | |||
REF_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
REF_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
REF_DOC_TRX_ID | NUMBER | |||
REF_DOC_LINE_ID | NUMBER | |||
REF_DOC_DIST_ID | NUMBER | |||
REF_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
MINIMUM_ACCOUNTABLE_UNIT | NUMBER | |||
PRECISION | NUMBER | |||
ROUNDING_RULE_CODE | VARCHAR2 | (30) | ||
TAXABLE_AMT | NUMBER | |||
TAXABLE_AMT_TAX_CURR | NUMBER | |||
TAXABLE_AMT_FUNCL_CURR | NUMBER | |||
TAX_ONLY_LINE_FLAG | VARCHAR2 | (1) | ||
UNROUNDED_TAXABLE_AMT | NUMBER | |||
LEGAL_ENTITY_ID | NUMBER | |||
PRD_TAX_AMT | NUMBER | |||
PRD_TAX_AMT_TAX_CURR | NUMBER | |||
PRD_TAX_AMT_FUNCL_CURR | NUMBER | |||
PRD_TOTAL_TAX_AMT | NUMBER | |||
PRD_TOTAL_TAX_AMT_TAX_CURR | NUMBER | |||
PRD_TOTAL_TAX_AMT_FUNCL_CURR | NUMBER | |||
APPLIED_FROM_TAX_DIST_ID | NUMBER | |||
APPLIED_TO_DOC_CURR_CONV_RATE | NUMBER | |||
ADJUSTED_DOC_TAX_DIST_ID | NUMBER | |||
FUNC_CURR_ROUNDING_ADJUSTMENT | NUMBER | |||
TAX_APPORTIONMENT_LINE_NUMBER | NUMBER | |||
LAST_MANUAL_ENTRY | VARCHAR2 | (30) | ||
REF_DOC_TAX_DIST_ID | NUMBER | |||
MRC_TAX_DIST_FLAG | VARCHAR2 | (1) | ||
MRC_LINK_TO_TAX_DIST_ID | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
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) | ||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
ORIG_AP_CHRG_DIST_NUM | NUMBER | |||
ORIG_AP_CHRG_DIST_ID | NUMBER | |||
ORIG_AP_TAX_DIST_NUM | NUMBER | |||
ORIG_AP_TAX_DIST_ID | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, REC_NREC_TAX_DIST_ID
, APPLICATION_ID
, ENTITY_CODE
, EVENT_CLASS_CODE
, EVENT_TYPE_CODE
, TRX_ID
, TRX_NUMBER
, TRX_LINE_ID
, TRX_LINE_NUMBER
, TAX_LINE_ID
, TAX_LINE_NUMBER
, TRX_LINE_DIST_ID
, TRX_LEVEL_TYPE
, ITEM_DIST_NUMBER
, REC_NREC_TAX_DIST_NUMBER
, REC_NREC_RATE
, RECOVERABLE_FLAG
, REC_NREC_TAX_AMT
, TAX_EVENT_CLASS_CODE
, TAX_EVENT_TYPE_CODE
, CONTENT_OWNER_ID
, TAX_REGIME_ID
, TAX_REGIME_CODE
, TAX_REGIME_NAME
, TAX_ID
, TAX
, TAX_FULL_NAME
, TAX_STATUS_ID
, TAX_STATUS_CODE
, TAX_STATUS_NAME
, TAX_RATE_ID
, TAX_RATE_CODE
, TAX_RATE_NAME
, TAX_RATE
, INCLUSIVE_FLAG
, RECOVERY_TYPE_ID
, RECOVERY_TYPE_CODE
, RECOVERY_RATE_ID
, RECOVERY_RATE_CODE
, REC_TYPE_RULE_FLAG
, NEW_REC_RATE_CODE_FLAG
, REVERSE_FLAG
, HISTORICAL_FLAG
, REVERSED_TAX_DIST_ID
, REC_NREC_TAX_AMT_TAX_CURR
, REC_NREC_TAX_AMT_FUNCL_CURR
, INTENDED_USE
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE
, REC_RATE_DET_RULE_FLAG
, LEDGER_ID
, SUMMARY_TAX_LINE_ID
, RECORD_TYPE_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, TAX_CURRENCY_CONVERSION_DATE
, TAX_CURRENCY_CONVERSION_TYPE
, TAX_CURRENCY_CONVERSION_RATE
, TRX_CURRENCY_CODE
, TAX_CURRENCY_CODE
, TRX_LINE_DIST_QTY
, REF_DOC_TRX_LINE_DIST_QTY
, PRICE_DIFF
, QTY_DIFF
, PER_TRX_CURR_UNIT_NR_AMT
, REF_PER_TRX_CURR_UNIT_NR_AMT
, REF_DOC_CURR_CONV_RATE
, UNIT_PRICE
, REF_DOC_UNIT_PRICE
, PER_UNIT_NREC_TAX_AMT
, REF_DOC_PER_UNIT_NREC_TAX_AMT
, RATE_TAX_FACTOR
, TAX_APPORTIONMENT_FLAG
, TRX_LINE_DIST_AMT
, TRX_LINE_DIST_TAX_AMT
, ORIG_REC_NREC_RATE
, ORIG_REC_RATE_CODE
, ORIG_REC_NREC_TAX_AMT
, ORIG_REC_NREC_TAX_AMT_TAX_CURR
, ACCOUNT_CCID
, ACCOUNT_STRING
, UNROUNDED_REC_NREC_TAX_AMT
, APPLICABILITY_RESULT_ID
, REC_RATE_RESULT_ID
, BACKWARD_COMPATIBILITY_FLAG
, OVERRIDDEN_FLAG
, SELF_ASSESSED_FLAG
, FREEZE_FLAG
, POSTING_FLAG
, GL_DATE
, REF_DOC_APPLICATION_ID
, REF_DOC_ENTITY_CODE
, REF_DOC_EVENT_CLASS_CODE
, REF_DOC_TRX_ID
, REF_DOC_LINE_ID
, REF_DOC_DIST_ID
, REF_DOC_TRX_LEVEL_TYPE
, MINIMUM_ACCOUNTABLE_UNIT
, PRECISION
, ROUNDING_RULE_CODE
, TAXABLE_AMT
, TAXABLE_AMT_TAX_CURR
, TAXABLE_AMT_FUNCL_CURR
, TAX_ONLY_LINE_FLAG
, UNROUNDED_TAXABLE_AMT
, LEGAL_ENTITY_ID
, PRD_TAX_AMT
, PRD_TAX_AMT_TAX_CURR
, PRD_TAX_AMT_FUNCL_CURR
, PRD_TOTAL_TAX_AMT
, PRD_TOTAL_TAX_AMT_TAX_CURR
, PRD_TOTAL_TAX_AMT_FUNCL_CURR
, APPLIED_FROM_TAX_DIST_ID
, APPLIED_TO_DOC_CURR_CONV_RATE
, ADJUSTED_DOC_TAX_DIST_ID
, FUNC_CURR_ROUNDING_ADJUSTMENT
, TAX_APPORTIONMENT_LINE_NUMBER
, LAST_MANUAL_ENTRY
, REF_DOC_TAX_DIST_ID
, MRC_TAX_DIST_FLAG
, MRC_LINK_TO_TAX_DIST_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, ORIG_AP_CHRG_DIST_NUM
, ORIG_AP_CHRG_DIST_ID
, ORIG_AP_TAX_DIST_NUM
, ORIG_AP_TAX_DIST_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.ZX_REC_NREC_DIST_V;
APPS.ZX_REC_NREC_DIST_V is not referenced by any database object
|
|
|