[Home] [Help] [Dependency Information]

VIEW: APPS.GML_GPOAO_ORDER_TEXT_V

Object Details

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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

Contains sales order header text data to support the OPM Outbound Purchase Order Acknowledgement (855/ORDRSP) EDI transaction.
This view is used to populate the GML_GPOAO_ORDER_TEXT table by primarily viewing data stored in the OP_TEXT_TBL table in OPM Order Fulfillment.

[View Source]

Columns

Query Text

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

SELECT ORDER_ID
,      LANG_CODE_INT
,      PARA_CODE_INT
,      SUB_PARACODE
,      LINE_NO
,      TEXT
FROM APPS.GML_GPOAO_ORDER_TEXT_V;

Dependencies

[top of page]

APPS

OP_ORDR_HDR

OP_TEXT_TBL

APPS.GML_GPOAO_ORDER_TEXT_V is not referenced by any database object