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

Object Details

Object Name:	POS_VIEW_ASN
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POS_VIEW_ASN POS.POS_VIEW_ASN
Subobject Name:
Status:	VALID

View Type

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

POS_VIEW_ASN displays records from RCV_HEADERS_INTERFACE and RCV_SHIPMENT_HEADERS for ASN and ASBN

[View Source]

Columns

Name	Datatype	Length	Comments
SHIPMENT_NUM	VARCHAR2	(30)	Shipment number assigned by the shipment's source
SHIPPED_DATE	DATE		Shipping date
EXPECTED_RECEIPT_DATE	DATE		Expected arrival date of the shipment
FREIGHT_CARRIER_CODE	VARCHAR2	(25)	Carrier responsible for shipping
INVOICE_NUM	VARCHAR2	(50)	Invoice Number
WAYBILL_AIRBILL_NUM	VARCHAR2	(30)	Waybill or airbill number
NUM_OF_CONTAINERS	NUMBER		Number of Containers
FREIGHT_TERMS	VARCHAR2	(25)	Freight payment method (user defined, e.g. PREPAID, COLLECT)
BILL_OF_LADING	VARCHAR2	(25)	Bill of lading number
PACKING_SLIP	VARCHAR2	(25)	Packing Slip number
PACKING_CODE	VARCHAR2	(5)	Shipment packaging code
VENDOR_NAME	VARCHAR2	(240)	Source supplier Name
VENDOR_NUMBER	VARCHAR2	(30)	Vendor Number
VENDOR_SITE_CODE	VARCHAR2	(15)	Source supplier Site Code
SPECIAL_HANDLING_CODE	VARCHAR2	(3)	Special Handling Code
TAR_WEIGHT	NUMBER		Shipment tar (container) weight from ASN
TAR_WEIGHT_UOM_CODE	VARCHAR2	(3)	Shipment tar (container) weight unit of measure from ASN
NET_WEIGHT	NUMBER		Shipment net weight from ASN
NET_WEIGHT_UOM_CODE	VARCHAR2	(3)	Shipment tar (container) weight unit of measure from ASN
COMMENTS	VARCHAR2	(4000)	Receiver's comments
CANCELLATION_STATUS	CHAR	(0)	Cancellation Status
PROCESSING_STATUS	CHAR	(0)	Processing status
VENDOR_ID	NUMBER		Source supplier unique ID
VENDOR_SITE_ID	NUMBER		Source supplier site unique identifier
PAYMENT_STATUS_FLAG	VARCHAR2	(1)	Payment Status Flag
CREATION_DATE	DATE		Creation Date
HEADER_ID	NUMBER		Header Id of ASN
SHIP_FROM_LOCATION_ID	NUMBER		Ship From Location Id
LOCATION_CODE	VARCHAR2	(30)	Ship From Location Code

Query Text

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


SELECT SHIPMENT_NUM
,      SHIPPED_DATE
,      EXPECTED_RECEIPT_DATE
,      FREIGHT_CARRIER_CODE
,      INVOICE_NUM
,      WAYBILL_AIRBILL_NUM
,      NUM_OF_CONTAINERS
,      FREIGHT_TERMS
,      BILL_OF_LADING
,      PACKING_SLIP
,      PACKING_CODE
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE_CODE
,      SPECIAL_HANDLING_CODE
,      TAR_WEIGHT
,      TAR_WEIGHT_UOM_CODE
,      NET_WEIGHT
,      NET_WEIGHT_UOM_CODE
,      COMMENTS
,      CANCELLATION_STATUS
,      PROCESSING_STATUS
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PAYMENT_STATUS_FLAG
,      CREATION_DATE
,      HEADER_ID
,      SHIP_FROM_LOCATION_ID
,      LOCATION_CODE
FROM APPS.POS_VIEW_ASN;

Dependencies

[top of page]

APPS.POS_VIEW_ASN references the following:

APPS: AP_INVOICES_ALL; FND_GLOBAL - show dependent code; HZ_PARTY_SITES; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_HEADERS_INTERFACE; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS_INTERFACE

APPS.POS_VIEW_ASN is not referenced by any database object