Skip to content

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

VIEW: APPS.ZX_P2P_CALC_TXN_INPUT_V

Object Details
Object Name: ZX_P2P_CALC_TXN_INPUT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewZX.ZX_P2P_CALC_TXN_INPUT_V
Subobject Name:
Status: VALID

[View Source]

Columns
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)
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 (40)
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 (15) Yes
APPLIED_FROM_TRX_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 (15) Yes
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 (150)
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_DATEE1 DATE

LINE_DATE2 DATE

LINE_DATEE3 DATE

LINE_DATE4 DATE

LINE_DATE5 DATE

EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
EXEMPT_REASON VARCHAR2 (240)
EXEMPTION_CONTROL_FLAG VARCHAR2 (1)
Query Text

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_TRX_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_DATEE1
,      LINE_DATE2
,      LINE_DATEE3
,      LINE_DATE4
,      LINE_DATE5
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON
,      EXEMPTION_CONTROL_FLAG
FROM APPS.ZX_P2P_CALC_TXN_INPUT_V;

Dependencies

[top of page]

APPS.ZX_P2P_CALC_TXN_INPUT_V references the following:

SchemaAPPS
SynonymZX_EVNT_CLS_MAPPINGS
SynonymZX_LINES_DET_FACTORS
SynonymZX_PRVDR_HDR_EXTNS_GT
SynonymZX_PRVDR_LINE_EXTNS_GT
SynonymZX_PTNR_LOCATION_INFO_GT
PL/SQL PackageZX_TPI_SERVICES_PKG - show dependent code
SynonymZX_TRX_PRE_PROC_OPTIONS_GT

APPS.ZX_P2P_CALC_TXN_INPUT_V is not referenced by any database object