[Home] [Help] [Dependency Information]
Object Name: | ECE_ADVO_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EC.ECE_ADVO_DETAILS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.ECE_ADVO_DETAILS_V is not referenced by any database object
|
|
|