Skip to content

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

VIEW: APPS.ZX_DETAIL_TAX_LINES_GT_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TAX_LINE_ID NUMBER (15) Yes
INTERNAL_ORGANIZATION_ID NUMBER
Yes
APPLICATION_ID NUMBER
Yes
ENTITY_CODE VARCHAR2 (30) Yes
EVENT_CLASS_CODE VARCHAR2 (30) Yes
EVENT_TYPE_CODE VARCHAR2 (30)
TRX_ID NUMBER
Yes
TRX_LINE_ID NUMBER
Yes
TRX_LEVEL_TYPE VARCHAR2 (30) Yes
TRX_LINE_NUMBER NUMBER

DOC_EVENT_STATUS VARCHAR2 (30)
TAX_EVENT_CLASS_CODE VARCHAR2 (30)
TAX_EVENT_TYPE_CODE VARCHAR2 (30)
TAX_LINE_NUMBER NUMBER
Yes
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

TAX_RATE_TYPE VARCHAR2 (30)
TAX_APPORTIONMENT_LINE_NUMBER NUMBER

TRX_ID_LEVEL2 NUMBER

TRX_ID_LEVEL3 NUMBER

TRX_ID_LEVEL4 NUMBER

TRX_ID_LEVEL5 NUMBER

TRX_ID_LEVEL6 NUMBER

TRX_USER_KEY_LEVEL1 VARCHAR2 (150)
TRX_USER_KEY_LEVEL2 VARCHAR2 (150)
TRX_USER_KEY_LEVEL3 VARCHAR2 (150)
TRX_USER_KEY_LEVEL4 VARCHAR2 (150)
TRX_USER_KEY_LEVEL5 VARCHAR2 (150)
TRX_USER_KEY_LEVEL6 VARCHAR2 (150)
MRC_TAX_LINE_FLAG VARCHAR2 (1)
LEDGER_ID NUMBER (15)
ESTABLISHMENT_ID NUMBER

HQ_ESTB_REG_NUMBER VARCHAR2 (30)
HQ_ESTB_PARTY_TAX_PROF_ID NUMBER

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)
REPORTING_CURRENCY_CODE VARCHAR2 (30)
MINIMUM_ACCOUNTABLE_UNIT NUMBER

PRECISION NUMBER

TRX_NUMBER VARCHAR2 (150)
TRX_DATE DATE

UNIT_PRICE NUMBER

LINE_AMT NUMBER

TRX_LINE_QUANTITY NUMBER

TAX_BASE_MODIFIER_RATE NUMBER

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_TRX_LEVEL_TYPE VARCHAR2 (30)
REF_DOC_LINE_ID NUMBER

REF_DOC_LINE_QUANTITY NUMBER

OTHER_DOC_LINE_AMT NUMBER

OTHER_DOC_LINE_TAX_AMT NUMBER

OTHER_DOC_LINE_TAXABLE_AMT NUMBER

UNROUNDED_TAXABLE_AMT NUMBER

UNROUNDED_TAX_AMT NUMBER

APPLIED_FROM_APPLICATION_ID NUMBER

APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 (30)
APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
APPLIED_FROM_TRX_ID NUMBER

APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2 (30)
APPLIED_FROM_LINE_ID NUMBER

APPLIED_FROM_TRX_NUMBER VARCHAR2 (150)
ADJUSTED_DOC_APPLICATION_ID NUMBER

ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
ADJUSTED_DOC_TRX_ID NUMBER

ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
ADJUSTED_DOC_LINE_ID NUMBER

ADJUSTED_DOC_NUMBER VARCHAR2 (150)
ADJUSTED_DOC_DATE DATE

APPLIED_TO_APPLICATION_ID NUMBER

APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 (30)
APPLIED_TO_ENTITY_CODE VARCHAR2 (30)
APPLIED_TO_TRX_ID NUMBER

APPLIED_TO_TRX_LEVEL_TYPE VARCHAR2 (30)
APPLIED_TO_LINE_ID NUMBER

SUMMARY_TAX_LINE_ID NUMBER (15)
OFFSET_FLAG VARCHAR2 (1)
PROCESS_FOR_RECOVERY_FLAG VARCHAR2 (1)
TAX_JURISDICTION_ID NUMBER (15)
TAX_JURISDICTION_CODE VARCHAR2 (30)
TAX_JURISDICTION_NAME VARCHAR2 (240)
PLACE_OF_SUPPLY NUMBER

PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 (30)
PLACE_OF_SUPPLY_RESULT_ID NUMBER (15)
TAX_DATE_RULE_ID NUMBER (15)
TAX_DATE DATE

TAX_DETERMINE_DATE DATE

TAX_POINT_DATE DATE

TRX_LINE_DATE DATE

TAX_TYPE_CODE VARCHAR2 (30)
TAX_CODE VARCHAR2 (30)
TAX_REGISTRATION_ID NUMBER (15)
TAX_REGISTRATION_NUMBER VARCHAR2 (50)
REGISTRATION_PARTY_TYPE VARCHAR2 (30)
ROUNDING_LEVEL_CODE VARCHAR2 (30)
ROUNDING_RULE_CODE VARCHAR2 (30)
ROUNDING_LVL_PARTY_TAX_PROF_ID NUMBER (15)
ROUNDING_LVL_PARTY_TYPE VARCHAR2 (30)
COMPOUNDING_TAX_FLAG VARCHAR2 (1)
ORIG_TAX_STATUS_ID NUMBER (15)
ORIG_TAX_STATUS_CODE VARCHAR2 (30)
ORIG_TAX_RATE_ID NUMBER (15)
ORIG_TAX_RATE_CODE VARCHAR2 (150)
ORIG_TAX_RATE NUMBER

ORIG_TAX_JURISDICTION_ID NUMBER (15)
ORIG_TAX_JURISDICTION_CODE VARCHAR2 (30)
ORIG_TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
ORIG_SELF_ASSESSED_FLAG VARCHAR2 (1)
TAX_CURRENCY_CODE VARCHAR2 (15)
TAX_AMT NUMBER

TAX_AMT_TAX_CURR NUMBER

TAX_AMT_FUNCL_CURR NUMBER

TAXABLE_AMT NUMBER

TAXABLE_AMT_TAX_CURR NUMBER

TAXABLE_AMT_FUNCL_CURR NUMBER

ORIG_TAXABLE_AMT NUMBER

ORIG_TAXABLE_AMT_TAX_CURR NUMBER

CAL_TAX_AMT NUMBER

CAL_TAX_AMT_TAX_CURR NUMBER

CAL_TAX_AMT_FUNCL_CURR NUMBER

ORIG_TAX_AMT NUMBER

ORIG_TAX_AMT_TAX_CURR NUMBER

REC_TAX_AMT NUMBER

REC_TAX_AMT_TAX_CURR NUMBER

REC_TAX_AMT_FUNCL_CURR NUMBER

NREC_TAX_AMT NUMBER

NREC_TAX_AMT_TAX_CURR NUMBER

NREC_TAX_AMT_FUNCL_CURR NUMBER

TAX_EXEMPTION_ID NUMBER (15)
TAX_RATE_BEFORE_EXEMPTION NUMBER

TAX_RATE_NAME_BEFORE_EXEMPTION VARCHAR2 (150)
EXEMPT_RATE_MODIFIER NUMBER

EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
EXEMPT_REASON VARCHAR2 (240)
EXEMPT_REASON_CODE VARCHAR2 (30)
TAX_EXCEPTION_ID NUMBER (15)
TAX_RATE_BEFORE_EXCEPTION NUMBER

TAX_RATE_NAME_BEFORE_EXCEPTION VARCHAR2 (150)
EXCEPTION_RATE NUMBER

TAX_APPORTIONMENT_FLAG VARCHAR2 (1)
HISTORICAL_FLAG VARCHAR2 (1)
TAXABLE_BASIS_FORMULA VARCHAR2 (30)
TAX_CALCULATION_FORMULA VARCHAR2 (30)
CANCEL_FLAG VARCHAR2 (1)
PURGE_FLAG VARCHAR2 (1)
DELETE_FLAG VARCHAR2 (1)
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
SELF_ASSESSED_FLAG VARCHAR2 (1)
OVERRIDDEN_FLAG VARCHAR2 (1)
MANUALLY_ENTERED_FLAG VARCHAR2 (1)
REPORTING_ONLY_FLAG VARCHAR2 (1)
FREEZE_UNTIL_OVERRIDDEN_FLAG VARCHAR2 (1)
COPIED_FROM_OTHER_DOC_FLAG VARCHAR2 (1)
RECALC_REQUIRED_FLAG VARCHAR2 (1)
SETTLEMENT_FLAG VARCHAR2 (1)
ITEM_DIST_CHANGED_FLAG VARCHAR2 (1)
ASSOCIATED_CHILD_FROZEN_FLAG VARCHAR2 (1)
TAX_ONLY_LINE_FLAG VARCHAR2 (1)
COMPOUNDING_DEP_TAX_FLAG VARCHAR2 (1)
COMPOUNDING_TAX_MISS_FLAG VARCHAR2 (1)
SYNC_WITH_PRVDR_FLAG VARCHAR2 (1)
LAST_MANUAL_ENTRY VARCHAR2 (30)
TAX_PROVIDER_ID NUMBER

RECORD_TYPE_CODE VARCHAR2 (30)
REPORTING_PERIOD_ID NUMBER

TAX_REGIME_TEMPLATE_ID NUMBER (15)
TAX_APPLICABILITY_RESULT_ID NUMBER (15)
DIRECT_RATE_RESULT_ID NUMBER (15)
STATUS_RESULT_ID NUMBER (15)
RATE_RESULT_ID NUMBER (15)
BASIS_RESULT_ID NUMBER (15)
THRESH_RESULT_ID NUMBER (15)
CALC_RESULT_ID NUMBER (15)
TAX_REG_NUM_DET_RESULT_ID NUMBER (15)
EVAL_EXMPT_RESULT_ID NUMBER (15)
EVAL_EXCPT_RESULT_ID NUMBER (15)
ENFORCE_FROM_NATURAL_ACCT_FLAG VARCHAR2 (1)
TAX_HOLD_CODE NUMBER

TAX_HOLD_RELEASED_CODE NUMBER

PRD_TOTAL_TAX_AMT NUMBER

PRD_TOTAL_TAX_AMT_TAX_CURR NUMBER

PRD_TOTAL_TAX_AMT_FUNCL_CURR NUMBER

TRX_LINE_INDEX VARCHAR2 (30)
OFFSET_TAX_RATE_CODE VARCHAR2 (150)
PRORATION_CODE VARCHAR2 (30)
OTHER_DOC_SOURCE VARCHAR2 (30)
INTERNAL_ORG_LOCATION_ID NUMBER

LINE_ASSESSABLE_VALUE NUMBER

CTRL_TOTAL_LINE_TX_AMT 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)
NUMERIC1 NUMBER

NUMERIC2 NUMBER

NUMERIC3 NUMBER

NUMERIC4 NUMBER

NUMERIC5 NUMBER

NUMERIC6 NUMBER

NUMERIC7 NUMBER

NUMERIC8 NUMBER

NUMERIC9 NUMBER

NUMERIC10 NUMBER

CHAR1 VARCHAR2 (150)
CHAR2 VARCHAR2 (150)
CHAR3 VARCHAR2 (150)
CHAR4 VARCHAR2 (150)
CHAR5 VARCHAR2 (150)
CHAR6 VARCHAR2 (150)
CHAR7 VARCHAR2 (150)
CHAR8 VARCHAR2 (150)
CHAR9 VARCHAR2 (150)
CHAR10 VARCHAR2 (150)
DATE1 DATE

DATE2 DATE

DATE3 DATE

DATE4 DATE

DATE5 DATE

DATE6 DATE

DATE7 DATE

DATE8 DATE

DATE9 DATE

DATE10 DATE

APPLIED_TO_TRX_NUMBER VARCHAR2 (150)
INTERFACE_ENTITY_CODE VARCHAR2 (30)
INTERFACE_TAX_LINE_ID NUMBER

TAXING_JURIS_GEOGRAPHY_ID NUMBER

ADJUSTED_DOC_TAX_LINE_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
,      TAX_LINE_ID
,      INTERNAL_ORGANIZATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      TRX_ID
,      TRX_LINE_ID
,      TRX_LEVEL_TYPE
,      TRX_LINE_NUMBER
,      DOC_EVENT_STATUS
,      TAX_EVENT_CLASS_CODE
,      TAX_EVENT_TYPE_CODE
,      TAX_LINE_NUMBER
,      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
,      TAX_RATE_TYPE
,      TAX_APPORTIONMENT_LINE_NUMBER
,      TRX_ID_LEVEL2
,      TRX_ID_LEVEL3
,      TRX_ID_LEVEL4
,      TRX_ID_LEVEL5
,      TRX_ID_LEVEL6
,      TRX_USER_KEY_LEVEL1
,      TRX_USER_KEY_LEVEL2
,      TRX_USER_KEY_LEVEL3
,      TRX_USER_KEY_LEVEL4
,      TRX_USER_KEY_LEVEL5
,      TRX_USER_KEY_LEVEL6
,      MRC_TAX_LINE_FLAG
,      MRC_LINK_TO_TAX_LINE_ID
,      LEDGER_ID
,      ESTABLISHMENT_ID
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_TAX_REG_NUMBER
,      HQ_ESTB_REG_NUMBER
,      HQ_ESTB_PARTY_TAX_PROF_ID
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      TAX_CURRENCY_CONVERSION_DATE
,      TAX_CURRENCY_CONVERSION_TYPE
,      TAX_CURRENCY_CONVERSION_RATE
,      TRX_CURRENCY_CODE
,      REPORTING_CURRENCY_CODE
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      TRX_NUMBER
,      TRX_DATE
,      UNIT_PRICE
,      LINE_AMT
,      TRX_LINE_QUANTITY
,      TAX_BASE_MODIFIER_RATE
,      REF_DOC_APPLICATION_ID
,      REF_DOC_ENTITY_CODE
,      REF_DOC_EVENT_CLASS_CODE
,      REF_DOC_TRX_ID
,      REF_DOC_TRX_LEVEL_TYPE
,      REF_DOC_LINE_ID
,      REF_DOC_LINE_QUANTITY
,      OTHER_DOC_LINE_AMT
,      OTHER_DOC_LINE_TAX_AMT
,      OTHER_DOC_LINE_TAXABLE_AMT
,      UNROUNDED_TAXABLE_AMT
,      UNROUNDED_TAX_AMT
,      RELATED_DOC_APPLICATION_ID
,      RELATED_DOC_ENTITY_CODE
,      RELATED_DOC_EVENT_CLASS_CODE
,      RELATED_DOC_TRX_ID
,      RELATED_DOC_TRX_LEVEL_TYPE
,      RELATED_DOC_NUMBER
,      RELATED_DOC_DATE
,      APPLIED_FROM_APPLICATION_ID
,      APPLIED_FROM_EVENT_CLASS_CODE
,      APPLIED_FROM_ENTITY_CODE
,      APPLIED_FROM_TRX_ID
,      APPLIED_FROM_TRX_LEVEL_TYPE
,      APPLIED_FROM_LINE_ID
,      APPLIED_FROM_TRX_NUMBER
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_ID
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      ADJUSTED_DOC_LINE_ID
,      ADJUSTED_DOC_NUMBER
,      ADJUSTED_DOC_DATE
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_EVENT_CLASS_CODE
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_TRX_ID
,      APPLIED_TO_TRX_LEVEL_TYPE
,      APPLIED_TO_LINE_ID
,      SUMMARY_TAX_LINE_ID
,      OFFSET_LINK_TO_TAX_LINE_ID
,      OFFSET_FLAG
,      PROCESS_FOR_RECOVERY_FLAG
,      TAX_JURISDICTION_ID
,      TAX_JURISDICTION_CODE
,      TAX_JURISDICTION_NAME
,      PLACE_OF_SUPPLY
,      PLACE_OF_SUPPLY_TYPE_CODE
,      PLACE_OF_SUPPLY_RESULT_ID
,      TAX_DATE_RULE_ID
,      TAX_DATE
,      TAX_DETERMINE_DATE
,      TAX_POINT_DATE
,      TRX_LINE_DATE
,      TAX_TYPE_CODE
,      TAX_CODE
,      TAX_REGISTRATION_ID
,      TAX_REGISTRATION_NUMBER
,      REGISTRATION_PARTY_TYPE
,      ROUNDING_LEVEL_CODE
,      ROUNDING_RULE_CODE
,      ROUNDING_LVL_PARTY_TAX_PROF_ID
,      ROUNDING_LVL_PARTY_TYPE
,      COMPOUNDING_TAX_FLAG
,      ORIG_TAX_STATUS_ID
,      ORIG_TAX_STATUS_CODE
,      ORIG_TAX_RATE_ID
,      ORIG_TAX_RATE_CODE
,      ORIG_TAX_RATE
,      ORIG_TAX_JURISDICTION_ID
,      ORIG_TAX_JURISDICTION_CODE
,      ORIG_TAX_AMT_INCLUDED_FLAG
,      ORIG_SELF_ASSESSED_FLAG
,      TAX_CURRENCY_CODE
,      TAX_AMT
,      TAX_AMT_TAX_CURR
,      TAX_AMT_FUNCL_CURR
,      TAXABLE_AMT
,      TAXABLE_AMT_TAX_CURR
,      TAXABLE_AMT_FUNCL_CURR
,      ORIG_TAXABLE_AMT
,      ORIG_TAXABLE_AMT_TAX_CURR
,      CAL_TAX_AMT
,      CAL_TAX_AMT_TAX_CURR
,      CAL_TAX_AMT_FUNCL_CURR
,      ORIG_TAX_AMT
,      ORIG_TAX_AMT_TAX_CURR
,      REC_TAX_AMT
,      REC_TAX_AMT_TAX_CURR
,      REC_TAX_AMT_FUNCL_CURR
,      NREC_TAX_AMT
,      NREC_TAX_AMT_TAX_CURR
,      NREC_TAX_AMT_FUNCL_CURR
,      TAX_EXEMPTION_ID
,      TAX_RATE_BEFORE_EXEMPTION
,      TAX_RATE_NAME_BEFORE_EXEMPTION
,      EXEMPT_RATE_MODIFIER
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON
,      EXEMPT_REASON_CODE
,      TAX_EXCEPTION_ID
,      TAX_RATE_BEFORE_EXCEPTION
,      TAX_RATE_NAME_BEFORE_EXCEPTION
,      EXCEPTION_RATE
,      TAX_APPORTIONMENT_FLAG
,      HISTORICAL_FLAG
,      TAXABLE_BASIS_FORMULA
,      TAX_CALCULATION_FORMULA
,      CANCEL_FLAG
,      PURGE_FLAG
,      DELETE_FLAG
,      TAX_AMT_INCLUDED_FLAG
,      SELF_ASSESSED_FLAG
,      OVERRIDDEN_FLAG
,      MANUALLY_ENTERED_FLAG
,      REPORTING_ONLY_FLAG
,      FREEZE_UNTIL_OVERRIDDEN_FLAG
,      COPIED_FROM_OTHER_DOC_FLAG
,      RECALC_REQUIRED_FLAG
,      SETTLEMENT_FLAG
,      ITEM_DIST_CHANGED_FLAG
,      ASSOCIATED_CHILD_FROZEN_FLAG
,      TAX_ONLY_LINE_FLAG
,      COMPOUNDING_DEP_TAX_FLAG
,      COMPOUNDING_TAX_MISS_FLAG
,      SYNC_WITH_PRVDR_FLAG
,      LAST_MANUAL_ENTRY
,      TAX_PROVIDER_ID
,      RECORD_TYPE_CODE
,      REPORTING_PERIOD_ID
,      LEGAL_JUSTIFICATION_TEXT1
,      LEGAL_JUSTIFICATION_TEXT2
,      LEGAL_JUSTIFICATION_TEXT3
,      LEGAL_MESSAGE_APPL_2
,      LEGAL_MESSAGE_STATUS
,      LEGAL_MESSAGE_RATE
,      LEGAL_MESSAGE_BASIS
,      LEGAL_MESSAGE_CALC
,      LEGAL_MESSAGE_THRESHOLD
,      LEGAL_MESSAGE_POS
,      LEGAL_MESSAGE_TRN
,      LEGAL_MESSAGE_EXMPT
,      LEGAL_MESSAGE_EXCPT
,      TAX_REGIME_TEMPLATE_ID
,      TAX_APPLICABILITY_RESULT_ID
,      DIRECT_RATE_RESULT_ID
,      STATUS_RESULT_ID
,      RATE_RESULT_ID
,      BASIS_RESULT_ID
,      THRESH_RESULT_ID
,      CALC_RESULT_ID
,      TAX_REG_NUM_DET_RESULT_ID
,      EVAL_EXMPT_RESULT_ID
,      EVAL_EXCPT_RESULT_ID
,      ENFORCE_FROM_NATURAL_ACCT_FLAG
,      TAX_HOLD_CODE
,      TAX_HOLD_RELEASED_CODE
,      PRD_TOTAL_TAX_AMT
,      PRD_TOTAL_TAX_AMT_TAX_CURR
,      PRD_TOTAL_TAX_AMT_FUNCL_CURR
,      TRX_LINE_INDEX
,      OFFSET_TAX_RATE_CODE
,      PRORATION_CODE
,      OTHER_DOC_SOURCE
,      INTERNAL_ORG_LOCATION_ID
,      LINE_ASSESSABLE_VALUE
,      CTRL_TOTAL_LINE_TX_AMT
,      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
,      NUMERIC1
,      NUMERIC2
,      NUMERIC3
,      NUMERIC4
,      NUMERIC5
,      NUMERIC6
,      NUMERIC7
,      NUMERIC8
,      NUMERIC9
,      NUMERIC10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      CHAR10
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      DATE8
,      DATE9
,      DATE10
,      APPLIED_TO_TRX_NUMBER
,      INTERFACE_ENTITY_CODE
,      INTERFACE_TAX_LINE_ID
,      TAXING_JURIS_GEOGRAPHY_ID
,      ADJUSTED_DOC_TAX_LINE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.ZX_DETAIL_TAX_LINES_GT_V;

Dependencies

[top of page]

APPS.ZX_DETAIL_TAX_LINES_GT_V references the following:

SchemaAPPS
SynonymZX_DETAIL_TAX_LINES_GT
SynonymZX_JURISDICTIONS_TL
SynonymZX_RATES_TL
SynonymZX_REGIMES_TL
SynonymZX_STATUS_TL
SynonymZX_TAXES_TL

APPS.ZX_DETAIL_TAX_LINES_GT_V is not referenced by any database object