eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ZX_SYNC_HDR_INPUT_V

Object Details

Object Name:	ZX_SYNC_HDR_INPUT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.ZX_SYNC_HDR_INPUT_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
INTERNAL_ORGANIZATION_ID	NUMBER		Yes
LEGAL_ENTITY_NUMBER	VARCHAR2	(30)
ESTABLISHMENT_NUMBER	VARCHAR2	(30)
DOCUMENT_TYPE_ID	NUMBER
TRANSACTION_ID	NUMBER		Yes
APPLICATION_CODE	VARCHAR2	(50)
DOCUMENT_LEVEL_ACTION	VARCHAR2	(30)
TRANSACTION_NUMBER	VARCHAR2	(150)
TRANSACTION_DESCRIPTION	VARCHAR2	(240)
DOCUMENT_SEQUENCE_VALUE	VARCHAR2	(240)
TRANSACTION_DUE_DATE	DATE
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

Query Text

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


SELECT INTERNAL_ORGANIZATION_ID
,      LEGAL_ENTITY_NUMBER
,      ESTABLISHMENT_NUMBER
,      DOCUMENT_TYPE_ID
,      TRANSACTION_ID
,      APPLICATION_CODE
,      DOCUMENT_LEVEL_ACTION
,      TRANSACTION_NUMBER
,      TRANSACTION_DESCRIPTION
,      DOCUMENT_SEQUENCE_VALUE
,      TRANSACTION_DUE_DATE
,      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
FROM APPS.ZX_SYNC_HDR_INPUT_V;

Dependencies

[top of page]

APPS.ZX_SYNC_HDR_INPUT_V references the following:

APPS: ZX_LINES_DET_FACTORS; ZX_PRVDR_HDR_EXTNS_GT; ZX_TRX_PRE_PROC_OPTIONS_GT

APPS.ZX_SYNC_HDR_INPUT_V is referenced by following:

APPS: ZX_TAXWARE_TAX_SERVICE_PKG - show dependent code; ZX_VERTEX_TAX_SERVICE_PKG - show dependent code