[Home] [Help] [Dependency Information]

VIEW: APPS.GML_GASNO_SHIPMENTS_V

Object Details

Object Name:	GML_GASNO_SHIPMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GML.GML_GASNO_SHIPMENTS_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 shipment header data to support the OPM Outbound Advanced Ship Notice (856/DESADV) EDI transaction.
This view is used to populate the GML_GASNO_SHIPMENTS table by primarily viewing data stored in the OP_BILL_LAD and OP_ORDR_HDR tables in OPM Order Fulfillment.

[View Source]

Columns

Query Text

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

SELECT COMMUNICATION_METHOD
,      TEST_INDICATOR
,      DOCUMENT_ID
,      TP_HEADER_ID
,      TP_DETAIL_ID
,      DOCUMENT_PURPOSE_CODE
,      TP_DOCUMENT_CODE
,      TP_CODE
,      TP_LOCATION_CODE_EXT
,      TP_DESCRIPTION
,      TP_REFERENCE1
,      TP_REFERENCE2
,      TRANSACTION_DATE
,      TP_HEADER_CATEGORY
,      TP_HEADER_ATTRIBUTE1
,      TP_HEADER_ATTRIBUTE2
,      TP_HEADER_ATTRIBUTE3
,      TP_HEADER_ATTRIBUTE4
,      TP_HEADER_ATTRIBUTE5
,      TP_HEADER_ATTRIBUTE6
,      TP_HEADER_ATTRIBUTE7
,      TP_HEADER_ATTRIBUTE8
,      TP_HEADER_ATTRIBUTE9
,      TP_HEADER_ATTRIBUTE10
,      TP_HEADER_ATTRIBUTE11
,      TP_HEADER_ATTRIBUTE12
,      TP_HEADER_ATTRIBUTE13
,      TP_HEADER_ATTRIBUTE14
,      TP_HEADER_ATTRIBUTE15
,      TP_DETAIL_CATEGORY
,      TP_DETAIL_ATTRIBUTE1
,      TP_DETAIL_ATTRIBUTE2
,      TP_DETAIL_ATTRIBUTE3
,      TP_DETAIL_ATTRIBUTE4
,      TP_DETAIL_ATTRIBUTE5
,      BOL_ID
,      BOL_NO
,      ORGN_CODE
,      BOL_COMMENT
,      WAYBILL_NO
,      FRTBILL_MTHD_INT
,      FRTBILL_DESC
,      EMBARKATION_PORT_INT
,      EMBARKATION_PORT_DESC
,      DEBARKATION_PORT_INT
,      DEBARKATION_PORT_DESC
,      FOB_CODE_INT
,      FOB_NAME
,      SHIPPER_CODE_INT
,      SHIPPER_NAME
,      SHIP_MTHD_INT
,      METH_DESC1
,      NET_WT
,      TARE_WT
,      PALLET_WT
,      BOLSHIP_WT
,      BOL_UM_INT
,      SHIP_VOLUME
,      SHIPVOLUME_UM_INT
,      SHIPTO_CUST_ID
,      SHIPTO_CODE_INT
,      SHIPTO_CODE_EXT1
,      SHIPTO_CODE_EXT2
,      SHIPTO_CODE_EXT3
,      SHIPTO_CUST_NAME
,      SHIPTO_ADDR1
,      SHIPTO_ADDR2
,      SHIPTO_ADDR3
,      SHIPTO_ADDR4
,      SHIPTO_POSTAL_CODE
,      SHIPTO_COUNTRY_CODE_INT
,      SHIPTO_STATE_CODE_INT
,      SHIPTO_PROVINCE_CODE_INT
,      SHIPTO_COUNTY
,      SHIPTO_LAST_NAME
,      SHIPTO_FIRST_NAME
,      SHIPTO_JOB_TITLE
,      SHIPTO_AREA_CODE
,      SHIPTO_TELEPHONE
,      BOLADDR_ID
,      BOLADDR_ADDR1
,      BOLADDR_ADDR2
,      BOLADDR_ADDR3
,      BOLADDR_ADDR4
,      BOLADDR_POSTAL_CODE
,      BOLADDR_COUNTRY_CODE_INT
,      BOLADDR_STATE_CODE_INT
,      BOLADDR_PROVINCE_CODE_INT
,      BOLADDR_COUNTY
,      EDI_TRANS_CNT
,      DROPOFF_TIME
,      PICKUP_TIME
,      PRINT_COUNT
,      PRINT_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DEMURRAGE_AMT
,      DEMURRAGE_CURRENCY_CODE_INT
,      FROM_WHSE
,      FROM_WHSE_NAME
,      FROM_WHSE_CONTACT
,      FROM_WHSE_PHONE
,      FROM_WHSE_ADDR1
,      FROM_WHSE_ADDR2
,      FROM_WHSE_ADDR3
,      FROM_WHSE_ADDR4
,      FROM_WHSE_POSTAL_CODE
,      FROM_WHSE_COUNTRY_CODE_INT
,      FROM_WHSE_STATE_CODE_INT
,      FROM_WHSE_PROVINCE_CODE_INT
,      FROM_WHSE_COUNTY
FROM APPS.GML_GASNO_SHIPMENTS_V;

Dependencies

[top of page]

APPS

ECE_TP_DETAILS

ECE_TP_HEADERS

FND_PROFILE - show dependent code

GML_EC_CONTACT_V

GML_GASNO_SUM_V

IC_WHSE_MST

OP_BILL_LAD

OP_CUST_MST

OP_FOBC_MST

OP_FRGT_MTH

OP_ORDR_DTL

OP_ORDR_HDR

OP_PORT_MST

OP_SHIP_MST

OP_SHIP_MTH

SY_ADDR_MST

APPS.GML_GASNO_SHIPMENTS_V is not referenced by any database object