[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_O2C_CALC_TXN_INPUT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  FND.ZX_O2C_CALC_TXN_INPUT_V
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERNAL_ORGANIZATION_ID | NUMBER | Yes | ||
| DOCUMENT_TYPE_ID | NUMBER | |||
| TRANSACTION_ID | NUMBER | Yes | ||
| APPLICATION_CODE | VARCHAR2 | (50) | ||
| DOCUMENT_LEVEL_ACTION | VARCHAR2 | (30) | ||
| TRX_DATE | DATE | Yes | ||
| TRX_CURRENCY_CODE | VARCHAR2 | (15) | ||
| LEGAL_ENTITY_NUMBER | VARCHAR2 | (30) | ||
| ESTABLISHMENT_NUMBER | VARCHAR2 | (30) | ||
| TRANSACTION_NUMBER | VARCHAR2 | (150) | ||
| TRANSACTION_DESCRIPTION | VARCHAR2 | (240) | ||
| DOCUMENT_SEQUENCE_VALUE | VARCHAR2 | (240) | ||
| TRANSACTION_DUE_DATE | DATE | |||
| ALLOW_TAX_CALCULATION | VARCHAR2 | (1) | ||
| TRANSACTION_LINE_ID | NUMBER | |||
| TRX_LEVEL_TYPE | VARCHAR2 | (30) | Yes | |
| LINE_LEVEL_ACTION | VARCHAR2 | (30) | ||
| LINE_CLASS | VARCHAR2 | (30) | ||
| TRANSACTION_SHIPPING_DATE | DATE | |||
| TRANSACTION_RECEIPT_DATE | DATE | |||
| TRANSACTION_LINE_TYPE | VARCHAR2 | (30) | ||
| TRANSACTION_LINE_DATE | DATE | |||
| PROVNL_TAX_DETERMINATION_DATE | DATE | |||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | ||
| LINE_INTENDED_USE | VARCHAR2 | (240) | ||
| LINE_AMT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | ||
| LINE_AMOUNT | NUMBER | Yes | ||
| OTHER_INCLUSIVE_TAX_AMOUNT | NUMBER | |||
| TRANSACTION_LINE_QUANTITY | NUMBER | |||
| UNIT_PRICE | NUMBER | |||
| CASH_DISCOUNT | NUMBER | |||
| VOLUME_DISCOUNT | NUMBER | |||
| TRADING_DISCOUNT | NUMBER | |||
| TRANSPORTATION_CHARGE | NUMBER | |||
| INSURANCE_CHARGE | NUMBER | |||
| OTHER_CHARGE | NUMBER | |||
| PRODUCT_ID | NUMBER | |||
| UOM_CODE | VARCHAR2 | (30) | ||
| PRODUCT_TYPE | VARCHAR2 | (240) | ||
| PRODUCT_CODE | VARCHAR2 | (300) | ||
| FOB_POINT | VARCHAR2 | (30) | ||
| SHIP_TO_PARTY_NUMBER | VARCHAR2 | (30) | ||
| SHIP_TO_PARTY_NAME | VARCHAR2 | (360) | ||
| SHIP_FROM_PARTY_NUMBER | VARCHAR2 | (30) | ||
| SHIP_FROM_PARTY_NAME | VARCHAR2 | (360) | ||
| SHIP_TO_LOC_ID | NUMBER | |||
| SHIP_TO_GEOGRAPHY_TYPE1 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE1 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE2 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE2 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE3 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE3 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE4 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE4 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE5 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE5 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE6 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE6 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE7 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE7 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE8 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE8 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE9 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE9 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_TYPE10 | VARCHAR2 | (240) | ||
| SHIP_TO_GEOGRAPHY_VALUE10 | VARCHAR2 | (240) | ||
| SHIP_FROM_LOC_ID | NUMBER | |||
| SHIP_FROM_GEOGRAPHY_TYPE1 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE1 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE2 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE2 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE3 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE3 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE4 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE4 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE5 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE5 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE6 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE6 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE7 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE7 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE8 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE8 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE9 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE9 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_TYPE10 | VARCHAR2 | (240) | ||
| SHIP_FROM_GEOGRAPHY_VALUE10 | VARCHAR2 | (240) | ||
| POA_LOC_ID | NUMBER | |||
| POA_GEOGRAPHY_TYPE1 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE1 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE2 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE2 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE3 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE3 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE4 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE4 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE5 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE5 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE6 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE6 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE7 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE7 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE8 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE8 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE9 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE9 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_TYPE10 | VARCHAR2 | (240) | ||
| POA_GEOGRAPHY_VALUE10 | VARCHAR2 | (240) | ||
| POO_LOC_ID | NUMBER | |||
| POO_GEOGRAPHY_TYPE1 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE1 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE2 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE2 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE3 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE3 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE4 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE4 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE5 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE5 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE6 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE6 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE7 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE7 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE8 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE8 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE9 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE9 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_TYPE10 | VARCHAR2 | (240) | ||
| POO_GEOGRAPHY_VALUE10 | VARCHAR2 | (240) | ||
| BILL_TO_PARTY_NUMBER | VARCHAR2 | (30) | ||
| BILL_TO_PARTY_NAME | VARCHAR2 | (360) | ||
| BILL_FROM_PARTY_NUMBER | VARCHAR2 | (30) | ||
| BILL_FROM_PARTY_NAME | VARCHAR2 | (360) | ||
| BILL_TO_LOC_ID | NUMBER | |||
| BILL_TO_GEOGRAPHY_TYPE1 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE1 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE2 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE2 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE3 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE3 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE4 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE4 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE5 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE5 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE6 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE6 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE7 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE7 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE8 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE8 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE9 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE9 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_TYPE10 | VARCHAR2 | (240) | ||
| BILL_TO_GEOGRAPHY_VALUE10 | VARCHAR2 | (240) | ||
| BILL_FROM_LOC_ID | NUMBER | |||
| BILL_FROM_GEOGRAPHY_TYPE1 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE1 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE2 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE2 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE3 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE3 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE4 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE4 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE5 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE5 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE6 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE6 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE7 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE7 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE8 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE8 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE9 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE9 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_TYPE10 | VARCHAR2 | (240) | ||
| BILL_FROM_GEOGRAPHY_VALUE10 | VARCHAR2 | (240) | ||
| ACCOUNT_CCID | NUMBER | |||
| APPLIED_FROM_DOCUMENT_TYPE_ID | NUMBER | |||
| APPLIED_FROM_TRANSACTION_ID | NUMBER | |||
| APPLIED_FROM_LINE_ID | NUMBER | |||
| APPLIED_FROM_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| APPLIED_FROM_DOC_NUMBER | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_DOCUMENT_TYPE_ID | NUMBER | |||
| ADJUSTED_DOC_TRANSACTION_ID | NUMBER | |||
| ADJUSTED_DOC_LINE_ID | NUMBER | |||
| ADJUSTED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| ADJUSTED_DOC_NUMBER | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_DATE | DATE | |||
| ASSESSABLE_VALUE | NUMBER | |||
| TRX_LINE_NUMBER | NUMBER | |||
| TRX_LINE_DESCRIPTION | VARCHAR2 | (240) | ||
| PRODUCT_DESCRIPTION | VARCHAR2 | (240) | ||
| HEADER_CHAR1 | VARCHAR2 | (150) | ||
| HEADER_CHAR2 | VARCHAR2 | (150) | ||
| HEADER_CHAR3 | VARCHAR2 | (150) | ||
| HEADER_CHAR4 | VARCHAR2 | (150) | ||
| HEADER_CHAR5 | VARCHAR2 | (150) | ||
| HEADER_CHAR6 | VARCHAR2 | (150) | ||
| HEADER_CHAR7 | VARCHAR2 | (150) | ||
| HEADER_CHAR8 | VARCHAR2 | (150) | ||
| HEADER_CHAR9 | VARCHAR2 | (150) | ||
| HEADER_CHAR10 | VARCHAR2 | (150) | ||
| HEADER_CHAR11 | VARCHAR2 | (150) | ||
| HEADER_CHAR12 | VARCHAR2 | (150) | ||
| HEADER_CHAR13 | VARCHAR2 | (150) | ||
| HEADER_CHAR14 | VARCHAR2 | (150) | ||
| HEADER_CHAR15 | VARCHAR2 | (150) | ||
| HEADER_CHAR16 | VARCHAR2 | (150) | ||
| HEADER_CHAR17 | VARCHAR2 | (150) | ||
| HEADER_CHAR18 | VARCHAR2 | (150) | ||
| HEADER_CHAR19 | VARCHAR2 | (150) | ||
| HEADER_CHAR20 | VARCHAR2 | (150) | ||
| HEADER_CHAR21 | VARCHAR2 | (150) | ||
| HEADER_CHAR22 | VARCHAR2 | (150) | ||
| HEADER_CHAR23 | VARCHAR2 | (150) | ||
| HEADER_CHAR24 | VARCHAR2 | (150) | ||
| HEADER_CHAR25 | VARCHAR2 | (150) | ||
| HEADER_CHAR26 | VARCHAR2 | (150) | ||
| HEADER_CHAR27 | VARCHAR2 | (150) | ||
| HEADER_CHAR28 | VARCHAR2 | (150) | ||
| HEADER_CHAR29 | VARCHAR2 | (150) | ||
| HEADER_CHAR30 | VARCHAR2 | (150) | ||
| HEADER_NUMERIC1 | NUMBER | |||
| HEADER_NUMERIC2 | NUMBER | |||
| HEADER_NUMERIC3 | NUMBER | |||
| HEADER_NUMERIC4 | NUMBER | |||
| HEADER_NUMERIC5 | NUMBER | |||
| HEADER_NUMERIC6 | NUMBER | |||
| HEADER_NUMERIC7 | NUMBER | |||
| HEADER_NUMERIC8 | NUMBER | |||
| HEADER_NUMERIC9 | NUMBER | |||
| HEADER_NUMERIC10 | NUMBER | |||
| HEADER_DATE1 | DATE | |||
| HEADER_DATE2 | DATE | |||
| HEADER_DATE3 | DATE | |||
| HEADER_DATE4 | DATE | |||
| HEADER_DATE5 | DATE | |||
| LINE_CHAR1 | VARCHAR2 | (150) | ||
| LINE_CHAR2 | VARCHAR2 | (300) | ||
| LINE_CHAR3 | VARCHAR2 | (150) | ||
| LINE_CHAR4 | VARCHAR2 | (150) | ||
| LINE_CHAR5 | VARCHAR2 | (150) | ||
| LINE_CHAR6 | VARCHAR2 | (150) | ||
| LINE_CHAR7 | VARCHAR2 | (150) | ||
| LINE_CHAR8 | VARCHAR2 | (150) | ||
| LINE_CHAR9 | VARCHAR2 | (150) | ||
| LINE_CHAR10 | VARCHAR2 | (150) | ||
| LINE_CHAR11 | VARCHAR2 | (150) | ||
| LINE_CHAR12 | VARCHAR2 | (150) | ||
| LINE_CHAR13 | VARCHAR2 | (150) | ||
| LINE_CHAR14 | VARCHAR2 | (150) | ||
| LINE_CHAR15 | VARCHAR2 | (150) | ||
| LINE_CHAR16 | VARCHAR2 | (150) | ||
| LINE_CHAR17 | VARCHAR2 | (150) | ||
| LINE_CHAR18 | VARCHAR2 | (150) | ||
| LINE_CHAR19 | VARCHAR2 | (150) | ||
| LINE_CHAR20 | VARCHAR2 | (150) | ||
| LINE_CHAR21 | VARCHAR2 | (150) | ||
| LINE_CHAR22 | VARCHAR2 | (150) | ||
| LINE_CHAR23 | VARCHAR2 | (150) | ||
| LINE_CHAR24 | VARCHAR2 | (150) | ||
| LINE_CHAR25 | VARCHAR2 | (150) | ||
| LINE_CHAR26 | VARCHAR2 | (150) | ||
| LINE_CHAR27 | VARCHAR2 | (150) | ||
| LINE_CHAR28 | VARCHAR2 | (150) | ||
| LINE_CHAR29 | VARCHAR2 | (150) | ||
| LINE_CHAR30 | VARCHAR2 | (150) | ||
| LINE_NUMERIC1 | NUMBER | |||
| LINE_NUMERIC2 | NUMBER | |||
| LINE_NUMERIC3 | NUMBER | |||
| LINE_NUMERIC4 | NUMBER | |||
| LINE_NUMERIC5 | NUMBER | |||
| LINE_NUMERIC6 | NUMBER | |||
| LINE_NUMERIC7 | NUMBER | |||
| LINE_NUMERIC8 | NUMBER | |||
| LINE_NUMERIC9 | NUMBER | |||
| LINE_NUMERIC10 | NUMBER | |||
| LINE_DATE1 | DATE | |||
| LINE_DATE2 | DATE | |||
| LINE_DATE3 | DATE | |||
| LINE_DATE4 | DATE | |||
| LINE_DATE5 | DATE | |||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | ||
| EXEMPT_REASON | VARCHAR2 | (240) | ||
| EXEMPTION_CONTROL_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT INTERNAL_ORGANIZATION_ID
, DOCUMENT_TYPE_ID
, TRANSACTION_ID
, APPLICATION_CODE
, DOCUMENT_LEVEL_ACTION
, TRX_DATE
, TRX_CURRENCY_CODE
, LEGAL_ENTITY_NUMBER
, ESTABLISHMENT_NUMBER
, TRANSACTION_NUMBER
, TRANSACTION_DESCRIPTION
, DOCUMENT_SEQUENCE_VALUE
, TRANSACTION_DUE_DATE
, ALLOW_TAX_CALCULATION
, TRANSACTION_LINE_ID
, TRX_LEVEL_TYPE
, LINE_LEVEL_ACTION
, LINE_CLASS
, TRANSACTION_SHIPPING_DATE
, TRANSACTION_RECEIPT_DATE
, TRANSACTION_LINE_TYPE
, TRANSACTION_LINE_DATE
, PROVNL_TAX_DETERMINATION_DATE
, TRX_BUSINESS_CATEGORY
, LINE_INTENDED_USE
, LINE_AMT_INCLUDES_TAX_FLAG
, LINE_AMOUNT
, OTHER_INCLUSIVE_TAX_AMOUNT
, TRANSACTION_LINE_QUANTITY
, UNIT_PRICE
, CASH_DISCOUNT
, VOLUME_DISCOUNT
, TRADING_DISCOUNT
, TRANSPORTATION_CHARGE
, INSURANCE_CHARGE
, OTHER_CHARGE
, PRODUCT_ID
, UOM_CODE
, PRODUCT_TYPE
, PRODUCT_CODE
, FOB_POINT
, SHIP_TO_PARTY_NUMBER
, SHIP_TO_PARTY_NAME
, SHIP_FROM_PARTY_NUMBER
, SHIP_FROM_PARTY_NAME
, SHIP_TO_LOC_ID
, SHIP_TO_GEOGRAPHY_TYPE1
, SHIP_TO_GEOGRAPHY_VALUE1
, SHIP_TO_GEOGRAPHY_TYPE2
, SHIP_TO_GEOGRAPHY_VALUE2
, SHIP_TO_GEOGRAPHY_TYPE3
, SHIP_TO_GEOGRAPHY_VALUE3
, SHIP_TO_GEOGRAPHY_TYPE4
, SHIP_TO_GEOGRAPHY_VALUE4
, SHIP_TO_GEOGRAPHY_TYPE5
, SHIP_TO_GEOGRAPHY_VALUE5
, SHIP_TO_GEOGRAPHY_TYPE6
, SHIP_TO_GEOGRAPHY_VALUE6
, SHIP_TO_GEOGRAPHY_TYPE7
, SHIP_TO_GEOGRAPHY_VALUE7
, SHIP_TO_GEOGRAPHY_TYPE8
, SHIP_TO_GEOGRAPHY_VALUE8
, SHIP_TO_GEOGRAPHY_TYPE9
, SHIP_TO_GEOGRAPHY_VALUE9
, SHIP_TO_GEOGRAPHY_TYPE10
, SHIP_TO_GEOGRAPHY_VALUE10
, SHIP_FROM_LOC_ID
, SHIP_FROM_GEOGRAPHY_TYPE1
, SHIP_FROM_GEOGRAPHY_VALUE1
, SHIP_FROM_GEOGRAPHY_TYPE2
, SHIP_FROM_GEOGRAPHY_VALUE2
, SHIP_FROM_GEOGRAPHY_TYPE3
, SHIP_FROM_GEOGRAPHY_VALUE3
, SHIP_FROM_GEOGRAPHY_TYPE4
, SHIP_FROM_GEOGRAPHY_VALUE4
, SHIP_FROM_GEOGRAPHY_TYPE5
, SHIP_FROM_GEOGRAPHY_VALUE5
, SHIP_FROM_GEOGRAPHY_TYPE6
, SHIP_FROM_GEOGRAPHY_VALUE6
, SHIP_FROM_GEOGRAPHY_TYPE7
, SHIP_FROM_GEOGRAPHY_VALUE7
, SHIP_FROM_GEOGRAPHY_TYPE8
, SHIP_FROM_GEOGRAPHY_VALUE8
, SHIP_FROM_GEOGRAPHY_TYPE9
, SHIP_FROM_GEOGRAPHY_VALUE9
, SHIP_FROM_GEOGRAPHY_TYPE10
, SHIP_FROM_GEOGRAPHY_VALUE10
, POA_LOC_ID
, POA_GEOGRAPHY_TYPE1
, POA_GEOGRAPHY_VALUE1
, POA_GEOGRAPHY_TYPE2
, POA_GEOGRAPHY_VALUE2
, POA_GEOGRAPHY_TYPE3
, POA_GEOGRAPHY_VALUE3
, POA_GEOGRAPHY_TYPE4
, POA_GEOGRAPHY_VALUE4
, POA_GEOGRAPHY_TYPE5
, POA_GEOGRAPHY_VALUE5
, POA_GEOGRAPHY_TYPE6
, POA_GEOGRAPHY_VALUE6
, POA_GEOGRAPHY_TYPE7
, POA_GEOGRAPHY_VALUE7
, POA_GEOGRAPHY_TYPE8
, POA_GEOGRAPHY_VALUE8
, POA_GEOGRAPHY_TYPE9
, POA_GEOGRAPHY_VALUE9
, POA_GEOGRAPHY_TYPE10
, POA_GEOGRAPHY_VALUE10
, POO_LOC_ID
, POO_GEOGRAPHY_TYPE1
, POO_GEOGRAPHY_VALUE1
, POO_GEOGRAPHY_TYPE2
, POO_GEOGRAPHY_VALUE2
, POO_GEOGRAPHY_TYPE3
, POO_GEOGRAPHY_VALUE3
, POO_GEOGRAPHY_TYPE4
, POO_GEOGRAPHY_VALUE4
, POO_GEOGRAPHY_TYPE5
, POO_GEOGRAPHY_VALUE5
, POO_GEOGRAPHY_TYPE6
, POO_GEOGRAPHY_VALUE6
, POO_GEOGRAPHY_TYPE7
, POO_GEOGRAPHY_VALUE7
, POO_GEOGRAPHY_TYPE8
, POO_GEOGRAPHY_VALUE8
, POO_GEOGRAPHY_TYPE9
, POO_GEOGRAPHY_VALUE9
, POO_GEOGRAPHY_TYPE10
, POO_GEOGRAPHY_VALUE10
, BILL_TO_PARTY_NUMBER
, BILL_TO_PARTY_NAME
, BILL_FROM_PARTY_NUMBER
, BILL_FROM_PARTY_NAME
, BILL_TO_LOC_ID
, BILL_TO_GEOGRAPHY_TYPE1
, BILL_TO_GEOGRAPHY_VALUE1
, BILL_TO_GEOGRAPHY_TYPE2
, BILL_TO_GEOGRAPHY_VALUE2
, BILL_TO_GEOGRAPHY_TYPE3
, BILL_TO_GEOGRAPHY_VALUE3
, BILL_TO_GEOGRAPHY_TYPE4
, BILL_TO_GEOGRAPHY_VALUE4
, BILL_TO_GEOGRAPHY_TYPE5
, BILL_TO_GEOGRAPHY_VALUE5
, BILL_TO_GEOGRAPHY_TYPE6
, BILL_TO_GEOGRAPHY_VALUE6
, BILL_TO_GEOGRAPHY_TYPE7
, BILL_TO_GEOGRAPHY_VALUE7
, BILL_TO_GEOGRAPHY_TYPE8
, BILL_TO_GEOGRAPHY_VALUE8
, BILL_TO_GEOGRAPHY_TYPE9
, BILL_TO_GEOGRAPHY_VALUE9
, BILL_TO_GEOGRAPHY_TYPE10
, BILL_TO_GEOGRAPHY_VALUE10
, BILL_FROM_LOC_ID
, BILL_FROM_GEOGRAPHY_TYPE1
, BILL_FROM_GEOGRAPHY_VALUE1
, BILL_FROM_GEOGRAPHY_TYPE2
, BILL_FROM_GEOGRAPHY_VALUE2
, BILL_FROM_GEOGRAPHY_TYPE3
, BILL_FROM_GEOGRAPHY_VALUE3
, BILL_FROM_GEOGRAPHY_TYPE4
, BILL_FROM_GEOGRAPHY_VALUE4
, BILL_FROM_GEOGRAPHY_TYPE5
, BILL_FROM_GEOGRAPHY_VALUE5
, BILL_FROM_GEOGRAPHY_TYPE6
, BILL_FROM_GEOGRAPHY_VALUE6
, BILL_FROM_GEOGRAPHY_TYPE7
, BILL_FROM_GEOGRAPHY_VALUE7
, BILL_FROM_GEOGRAPHY_TYPE8
, BILL_FROM_GEOGRAPHY_VALUE8
, BILL_FROM_GEOGRAPHY_TYPE9
, BILL_FROM_GEOGRAPHY_VALUE9
, BILL_FROM_GEOGRAPHY_TYPE10
, BILL_FROM_GEOGRAPHY_VALUE10
, ACCOUNT_CCID
, APPLIED_FROM_DOCUMENT_TYPE_ID
, APPLIED_FROM_TRANSACTION_ID
, APPLIED_FROM_LINE_ID
, APPLIED_FROM_TRX_LEVEL_TYPE
, APPLIED_FROM_DOC_NUMBER
, ADJUSTED_DOC_DOCUMENT_TYPE_ID
, ADJUSTED_DOC_TRANSACTION_ID
, ADJUSTED_DOC_LINE_ID
, ADJUSTED_DOC_TRX_LEVEL_TYPE
, ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE
, ASSESSABLE_VALUE
, TRX_LINE_NUMBER
, TRX_LINE_DESCRIPTION
, PRODUCT_DESCRIPTION
, HEADER_CHAR1
, HEADER_CHAR2
, HEADER_CHAR3
, HEADER_CHAR4
, HEADER_CHAR5
, HEADER_CHAR6
, HEADER_CHAR7
, HEADER_CHAR8
, HEADER_CHAR9
, HEADER_CHAR10
, HEADER_CHAR11
, HEADER_CHAR12
, HEADER_CHAR13
, HEADER_CHAR14
, HEADER_CHAR15
, HEADER_CHAR16
, HEADER_CHAR17
, HEADER_CHAR18
, HEADER_CHAR19
, HEADER_CHAR20
, HEADER_CHAR21
, HEADER_CHAR22
, HEADER_CHAR23
, HEADER_CHAR24
, HEADER_CHAR25
, HEADER_CHAR26
, HEADER_CHAR27
, HEADER_CHAR28
, HEADER_CHAR29
, HEADER_CHAR30
, HEADER_NUMERIC1
, HEADER_NUMERIC2
, HEADER_NUMERIC3
, HEADER_NUMERIC4
, HEADER_NUMERIC5
, HEADER_NUMERIC6
, HEADER_NUMERIC7
, HEADER_NUMERIC8
, HEADER_NUMERIC9
, HEADER_NUMERIC10
, HEADER_DATE1
, HEADER_DATE2
, HEADER_DATE3
, HEADER_DATE4
, HEADER_DATE5
, LINE_CHAR1
, LINE_CHAR2
, LINE_CHAR3
, LINE_CHAR4
, LINE_CHAR5
, LINE_CHAR6
, LINE_CHAR7
, LINE_CHAR8
, LINE_CHAR9
, LINE_CHAR10
, LINE_CHAR11
, LINE_CHAR12
, LINE_CHAR13
, LINE_CHAR14
, LINE_CHAR15
, LINE_CHAR16
, LINE_CHAR17
, LINE_CHAR18
, LINE_CHAR19
, LINE_CHAR20
, LINE_CHAR21
, LINE_CHAR22
, LINE_CHAR23
, LINE_CHAR24
, LINE_CHAR25
, LINE_CHAR26
, LINE_CHAR27
, LINE_CHAR28
, LINE_CHAR29
, LINE_CHAR30
, LINE_NUMERIC1
, LINE_NUMERIC2
, LINE_NUMERIC3
, LINE_NUMERIC4
, LINE_NUMERIC5
, LINE_NUMERIC6
, LINE_NUMERIC7
, LINE_NUMERIC8
, LINE_NUMERIC9
, LINE_NUMERIC10
, LINE_DATE1
, LINE_DATE2
, LINE_DATE3
, LINE_DATE4
, LINE_DATE5
, EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON
, EXEMPTION_CONTROL_FLAG
FROM APPS.ZX_O2C_CALC_TXN_INPUT_V;
APPS
RA_CUST_TRX_TYPES_ALL
ZX_LINES_DET_FACTORS
ZX_PRVDR_HDR_EXTNS_GT
ZX_PRVDR_LINE_EXTNS_GT
ZX_PTNR_LOCATION_INFO_GT
ZX_SCO_RATES
ZX_SCO_TAXES
ZX_TPI_SERVICES_PKG
- show dependent code
ZX_TRX_PRE_PROC_OPTIONS_GT
APPS
ZX_TAXWARE_TAX_SERVICE_PKG
- show dependent code
ZX_TPI_SERVICES_PKG
- show dependent code
ZX_VERTEX_TAX_SERVICE_PKG
- show dependent code
|
|
|
|