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

VIEW: APPS.ZX_REC_NREC_DIST_QUOTE_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
REC_NREC_TAX_DIST_ID NUMBER (15)
APPLICATION_ID NUMBER

ENTITY_CODE VARCHAR2 (30)
EVENT_CLASS_CODE VARCHAR2 (30)
EVENT_TYPE_CODE VARCHAR2 (30)
TAX_EVENT_CLASS_CODE VARCHAR2 (30)
TAX_EVENT_TYPE_CODE VARCHAR2 (30)
TRX_ID NUMBER

TRX_LINE_ID NUMBER

TRX_LINE_NUMBER NUMBER

TAX_LINE_ID NUMBER (15)
TAX_LINE_NUMBER NUMBER

TRX_LINE_DIST_ID NUMBER

ITEM_DIST_NUMBER NUMBER

CONTENT_OWNER_ID NUMBER (15)
REC_NREC_TAX_DIST_NUMBER NUMBER

TAX_REGIME_ID NUMBER (15)
TAX_REGIME_CODE VARCHAR2 (30)
TAX_ID NUMBER (15)
TAX VARCHAR2 (30)
TAX_STATUS_ID NUMBER (15)
TAX_STATUS_CODE VARCHAR2 (30)
TAX_RATE_ID NUMBER (15)
TAX_RATE_CODE VARCHAR2 (150)
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_NREC_RATE NUMBER

REC_TYPE_RULE_FLAG VARCHAR2 (1)
NEW_REC_RATE_CODE_FLAG VARCHAR2 (1)
RECOVERABLE_FLAG VARCHAR2 (1)
REVERSE_FLAG VARCHAR2 (1)
HISTORICAL_FLAG VARCHAR2 (1)
REVERSED_TAX_DIST_ID NUMBER

REC_NREC_TAX_AMT 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_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

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)
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)
GL_DATE DATE

CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_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

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

ACCOUNT_CCID NUMBER

ACCOUNT_STRING VARCHAR2 (2000)
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

ADJUSTED_DOC_TAX_DIST_ID NUMBER

FUNC_CURR_ROUNDING_ADJUSTMENT NUMBER

GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
LAST_MANUAL_ENTRY VARCHAR2 (30)
TAX_APPORTIONMENT_LINE_NUMBER NUMBER

REF_DOC_TAX_DIST_ID NUMBER

MRC_TAX_DIST_FLAG VARCHAR2 (1)
MRC_LINK_TO_TAX_DIST_ID NUMBER

TAX_APPORTIONMENT_FLAG VARCHAR2 (1)
RATE_TAX_FACTOR NUMBER

REF_DOC_PER_UNIT_NREC_TAX_AMT NUMBER

PER_UNIT_NREC_TAX_AMT NUMBER

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

APPLIED_TO_DOC_CURR_CONV_RATE NUMBER

TRX_NUMBER VARCHAR2 (150)
TRX_LEVEL_TYPE VARCHAR2 (30)
REF_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
OBJECT_VERSION_NUMBER NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REC_NREC_TAX_DIST_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      TAX_EVENT_CLASS_CODE
,      TAX_EVENT_TYPE_CODE
,      TRX_ID
,      TRX_LINE_ID
,      TRX_LINE_NUMBER
,      TAX_LINE_ID
,      TAX_LINE_NUMBER
,      TRX_LINE_DIST_ID
,      ITEM_DIST_NUMBER
,      CONTENT_OWNER_ID
,      REC_NREC_TAX_DIST_NUMBER
,      TAX_REGIME_ID
,      TAX_REGIME_CODE
,      TAX_ID
,      TAX
,      TAX_STATUS_ID
,      TAX_STATUS_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      INCLUSIVE_FLAG
,      RECOVERY_TYPE_ID
,      RECOVERY_TYPE_CODE
,      RECOVERY_RATE_ID
,      RECOVERY_RATE_CODE
,      REC_NREC_RATE
,      REC_TYPE_RULE_FLAG
,      NEW_REC_RATE_CODE_FLAG
,      RECOVERABLE_FLAG
,      REVERSE_FLAG
,      HISTORICAL_FLAG
,      REVERSED_TAX_DIST_ID
,      REC_NREC_TAX_AMT
,      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_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
,      UNROUNDED_REC_NREC_TAX_AMT
,      APPLICABILITY_RESULT_ID
,      REC_RATE_RESULT_ID
,      BACKWARD_COMPATIBILITY_FLAG
,      OVERRIDDEN_FLAG
,      SELF_ASSESSED_FLAG
,      FREEZE_FLAG
,      POSTING_FLAG
,      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
,      GL_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_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
,      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
,      ACCOUNT_CCID
,      ACCOUNT_STRING
,      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
,      ADJUSTED_DOC_TAX_DIST_ID
,      FUNC_CURR_ROUNDING_ADJUSTMENT
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      LAST_MANUAL_ENTRY
,      TAX_APPORTIONMENT_LINE_NUMBER
,      REF_DOC_TAX_DIST_ID
,      MRC_TAX_DIST_FLAG
,      MRC_LINK_TO_TAX_DIST_ID
,      TAX_APPORTIONMENT_FLAG
,      RATE_TAX_FACTOR
,      REF_DOC_PER_UNIT_NREC_TAX_AMT
,      PER_UNIT_NREC_TAX_AMT
,      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
,      APPLIED_TO_DOC_CURR_CONV_RATE
,      TRX_NUMBER
,      TRX_LEVEL_TYPE
,      REF_DOC_TRX_LEVEL_TYPE
,      OBJECT_VERSION_NUMBER
FROM APPS.ZX_REC_NREC_DIST_QUOTE_V;

Dependencies

[top of page]

APPS.ZX_REC_NREC_DIST_QUOTE_V references the following:

SchemaAPPS
SynonymZX_LINES_DET_FACTORS
SynonymZX_REC_NREC_DIST
SynonymZX_REC_NREC_DIST_GT

APPS.ZX_REC_NREC_DIST_QUOTE_V is not referenced by any database object