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


VIEW: APPS.ECE_CDMO_HEADER_1_V

Object Details
Object Name: ECE_CDMO_HEADER_1_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEC.ECE_CDMO_HEADER_1_V
Subobject Name:
Status: VALID

View Type

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


This view extracts additional header information
for the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15)
Transaction ID
SHIP_FROM_CODE_INT VARCHAR2 (3)
Ship From Code (Internal)
EQUIPMENT_PREFIX VARCHAR2 (35)
Equipment Prefix
EQUIPMENT_NUMBER VARCHAR2 (35)
Equipment Number
ROUTING_INSTRUCTIONS VARCHAR2 (150)
Routing Instructions
PACKING_SLIP_NUMBER VARCHAR2 (50)
Packing Slip Number
CUSTOMER_TRX_LINE_ID NUMBER (15)
Customer Transaction Line Id
LINE_TYPE VARCHAR2 (20)
Line Type
PICKING_LINE_ID NUMBER

Picking Line Id
INTERFACE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Invoice Header Interface Flexfield Context
INTERFACE_ATTRIBUTE1 VARCHAR2 (150)
Invoice Header Interface Flexfield 1
INTERFACE_ATTRIBUTE2 VARCHAR2 (150)
Invoice Header Interface Flexfield 2
INTERFACE_ATTRIBUTE3 VARCHAR2 (150)
Invoice Header Interface Flexfield 3
INTERFACE_ATTRIBUTE4 VARCHAR2 (150)
Invoice Header Interface Flexfield 4
INTERFACE_ATTRIBUTE5 VARCHAR2 (150)
Invoice Header Interface Flexfield 5
INTERFACE_ATTRIBUTE6 VARCHAR2 (150)
Invoice Header Interface Flexfield 6
INTERFACE_ATTRIBUTE7 VARCHAR2 (150)
Invoice Header Interface Flexfield 7
INTERFACE_ATTRIBUTE8 VARCHAR2 (150)
Invoice Header Interface Flexfield 8
INTERFACE_ATTRIBUTE9 VARCHAR2 (150)
Invoice Header Interface Flexfield 9
INTERFACE_ATTRIBUTE10 VARCHAR2 (150)
Invoice Header Interface Flexfield 10
INTERFACE_ATTRIBUTE11 VARCHAR2 (150)
Invoice Header Interface Flexfield 11
INTERFACE_ATTRIBUTE12 VARCHAR2 (150)
Invoice Header Interface Flexfield 12
INTERFACE_ATTRIBUTE13 VARCHAR2 (150)
Invoice Header Interface Flexfield 13
INTERFACE_ATTRIBUTE14 VARCHAR2 (150)
Invoice Header Interface Flexfield 14
INTERFACE_ATTRIBUTE15 VARCHAR2 (150)
Invoice Header Interface Flexfield 15
TRANSACTION_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Invoice Header Flexfield Context
TRANSACTION_ATTRIBUTE1 VARCHAR2 (150)
Invoice Header Flexfield 1
TRANSACTION_ATTRIBUTE2 VARCHAR2 (150)
Invoice Header Flexfield 2
TRANSACTION_ATTRIBUTE3 VARCHAR2 (150)
Invoice Header Flexfield 3
TRANSACTION_ATTRIBUTE4 VARCHAR2 (150)
Invoice Header Flexfield 4
TRANSACTION_ATTRIBUTE5 VARCHAR2 (150)
Invoice Header Flexfield 5
TRANSACTION_ATTRIBUTE6 VARCHAR2 (150)
Invoice Header Flexfield 6
TRANSACTION_ATTRIBUTE7 VARCHAR2 (150)
Invoice Header Flexfield 7
TRANSACTION_ATTRIBUTE8 VARCHAR2 (150)
Invoice Header Flexfield 8
TRANSACTION_ATTRIBUTE9 VARCHAR2 (150)
Invoice Header Flexfield 9
TRANSACTION_ATTRIBUTE10 VARCHAR2 (150)
Invoice Header Flexfield 10
TRANSACTION_ATTRIBUTE11 VARCHAR2 (150)
Invoice Header Flexfield 11
TRANSACTION_ATTRIBUTE12 VARCHAR2 (150)
Invoice Header Flexfield 12
TRANSACTION_ATTRIBUTE13 VARCHAR2 (150)
Invoice Header Flexfield 13
TRANSACTION_ATTRIBUTE14 VARCHAR2 (150)
Invoice Header Flexfield 14
TRANSACTION_ATTRIBUTE15 VARCHAR2 (150)
Invoice Header Flexfield 15
DELIVERY_ID NUMBER

Delivery ID
Query Text

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


SELECT TRANSACTION_ID
,      SHIP_FROM_CODE_INT
,      EQUIPMENT_PREFIX
,      EQUIPMENT_NUMBER
,      ROUTING_INSTRUCTIONS
,      PACKING_SLIP_NUMBER
,      CUSTOMER_TRX_LINE_ID
,      LINE_TYPE
,      PICKING_LINE_ID
,      INTERFACE_ATTRIBUTE_CATEGORY
,      INTERFACE_ATTRIBUTE1
,      INTERFACE_ATTRIBUTE2
,      INTERFACE_ATTRIBUTE3
,      INTERFACE_ATTRIBUTE4
,      INTERFACE_ATTRIBUTE5
,      INTERFACE_ATTRIBUTE6
,      INTERFACE_ATTRIBUTE7
,      INTERFACE_ATTRIBUTE8
,      INTERFACE_ATTRIBUTE9
,      INTERFACE_ATTRIBUTE10
,      INTERFACE_ATTRIBUTE11
,      INTERFACE_ATTRIBUTE12
,      INTERFACE_ATTRIBUTE13
,      INTERFACE_ATTRIBUTE14
,      INTERFACE_ATTRIBUTE15
,      TRANSACTION_ATTRIBUTE_CATEGORY
,      TRANSACTION_ATTRIBUTE1
,      TRANSACTION_ATTRIBUTE2
,      TRANSACTION_ATTRIBUTE3
,      TRANSACTION_ATTRIBUTE4
,      TRANSACTION_ATTRIBUTE5
,      TRANSACTION_ATTRIBUTE6
,      TRANSACTION_ATTRIBUTE7
,      TRANSACTION_ATTRIBUTE8
,      TRANSACTION_ATTRIBUTE9
,      TRANSACTION_ATTRIBUTE10
,      TRANSACTION_ATTRIBUTE11
,      TRANSACTION_ATTRIBUTE12
,      TRANSACTION_ATTRIBUTE13
,      TRANSACTION_ATTRIBUTE14
,      TRANSACTION_ATTRIBUTE15
,      DELIVERY_ID
FROM APPS.ECE_CDMO_HEADER_1_V;

Dependencies

[top of page]

APPS.ECE_CDMO_HEADER_1_V references the following:

SchemaAPPS
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ORGANIZATION_INFORMATION
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymRA_CUSTOMER_TRX
SynonymRA_CUSTOMER_TRX_LINES
SynonymWSH_DELIVERY_DETAILS
SynonymWSH_DELIVERY_LEGS
SynonymWSH_DOCUMENT_INSTANCES
SynonymWSH_TRIPS
SynonymWSH_TRIP_STOPS

APPS.ECE_CDMO_HEADER_1_V is not referenced by any database object