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_LINES_INPUT_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
DOCUMENT_TYPE_ID	NUMBER
TRANSACTION_ID	NUMBER		Yes
TRANSACTION_LINE_ID	NUMBER
TRX_LEVEL_TYPE	VARCHAR2	(30)	Yes
TRX_LINE_NUMBER	NUMBER
TRX_LINE_DESCRIPTION	VARCHAR2	(240)
PRODUCT_DESCRIPTION	VARCHAR2	(240)
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

Query Text

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


SELECT DOCUMENT_TYPE_ID
,      TRANSACTION_ID
,      TRANSACTION_LINE_ID
,      TRX_LEVEL_TYPE
,      TRX_LINE_NUMBER
,      TRX_LINE_DESCRIPTION
,      PRODUCT_DESCRIPTION
,      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
FROM APPS.ZX_SYNC_LINES_INPUT_V;

Dependencies

[top of page]

APPS.ZX_SYNC_LINES_INPUT_V references the following:

APPS: ZX_LINES_DET_FACTORS; ZX_PRVDR_LINE_EXTNS_GT; ZX_TRX_PRE_PROC_OPTIONS_GT

APPS.ZX_SYNC_LINES_INPUT_V is not referenced by any database object