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.ECE_ADVO_DETAILS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view extracts advice details
for the outbound Application Advice (824/APERAK) transaction.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADVICE_DETAIL_ID	NUMBER		Yes	Advice Detail ID
ADVICE_HEADER_ID	NUMBER			Advice Header ID
ADVO_DATE_TIME	DATE			Advice Date/Time
ADVO_STATUS_CODE	VARCHAR2	(30)		Advice Status
EXTERNAL_REFERENCE1	VARCHAR2	(80)		Advice External Reference 1
EXTERNAL_REFERENCE2	VARCHAR2	(80)		Advice External Reference 2
EXTERNAL_REFERENCE3	VARCHAR2	(80)		Advice External Reference 3
EXTERNAL_REFERENCE4	VARCHAR2	(80)		Advice External Reference 4
EXTERNAL_REFERENCE5	VARCHAR2	(80)		Advice External Reference 5
EXTERNAL_REFERENCE6	VARCHAR2	(80)		Advice External Reference 6
INTERNAL_REFERENCE1	VARCHAR2	(80)		Advice Internal Reference 1
INTERNAL_REFERENCE2	VARCHAR2	(80)		Advice Internal Reference 2
INTERNAL_REFERENCE3	VARCHAR2	(80)		Advice Internal Reference 3
INTERNAL_REFERENCE4	VARCHAR2	(80)		Advice Internal Reference 4
INTERNAL_REFERENCE5	VARCHAR2	(80)		Advice Internal Reference 5
INTERNAL_REFERENCE6	VARCHAR2	(80)		Advice Internal Reference 6
ADVO_MESSAGE_CODE	VARCHAR2	(30)		Advice Message Code
ADVO_MESSAGE_DESC	VARCHAR2	(240)		Advice Message Description
ADVO_DATA_BAD	VARCHAR2	(240)		Advice Data - Bad
ADVO_DATA_GOOD	VARCHAR2	(240)		Advice Data - Good

Query Text

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


SELECT ADVICE_DETAIL_ID
,      ADVICE_HEADER_ID
,      ADVO_DATE_TIME
,      ADVO_STATUS_CODE
,      EXTERNAL_REFERENCE1
,      EXTERNAL_REFERENCE2
,      EXTERNAL_REFERENCE3
,      EXTERNAL_REFERENCE4
,      EXTERNAL_REFERENCE5
,      EXTERNAL_REFERENCE6
,      INTERNAL_REFERENCE1
,      INTERNAL_REFERENCE2
,      INTERNAL_REFERENCE3
,      INTERNAL_REFERENCE4
,      INTERNAL_REFERENCE5
,      INTERNAL_REFERENCE6
,      ADVO_MESSAGE_CODE
,      ADVO_MESSAGE_DESC
,      ADVO_DATA_BAD
,      ADVO_DATA_GOOD
FROM APPS.ECE_ADVO_DETAILS_V;

Dependencies

[top of page]

APPS.ECE_ADVO_DETAILS_V references the following:

APPS: ECE_ADVO_DETAILS

APPS.ECE_ADVO_DETAILS_V is not referenced by any database object