Skip to content

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

VIEW: APPS.ZX_REC_NREC_DIST_V

Object Details
Object Name: ZX_REC_NREC_DIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.ZX_REC_NREC_DIST_V
Subobject Name:
Status: VALID

[View Source]

Columns
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

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)
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)
Query Text

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;

Dependencies

[top of page]

APPS.ZX_REC_NREC_DIST_V references the following:

SchemaAPPS
SynonymZX_RATES_TL
SynonymZX_REC_NREC_DIST
SynonymZX_REGIMES_TL
SynonymZX_STATUS_TL
SynonymZX_TAXES_TL

APPS.ZX_REC_NREC_DIST_V is not referenced by any database object