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_HEADERS_V

Object Details

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

View Type

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

POS_HEADERS_V is the view used to select the header info for Advance Shipment Notice created

[View Source]

Columns

Name	Datatype	Length	Comments
SHIPMENT_NUM	VARCHAR2	(30)	Shipment Number
SHIPPED_DATE	DATE		Shipped Date
EXPECTED_RECEIPT_DATE	DATE		Expected Receipt Date
FREIGHT_TERMS	VARCHAR2	(25)	Freight Terms
FREIGHT_CARRIER_CODE	VARCHAR2	(25)	Freight Carrier Code
FREIGHT_BILL_NUMBER	VARCHAR2	(35)	Freight Bill Number
NUM_OF_CONTAINERS	NUMBER		Number of Containers
BILL_OF_LADING	VARCHAR2	(25)	Bill of Lading
WAYBILL_AIRBILL_NUM	VARCHAR2	(30)	Waybill Airbill Number
INVOICE_NUM	VARCHAR2	(50)	Invoice Number
INVOICE_DATE	DATE		Invoice Date
TOTAL_INVOICE_AMOUNT	NUMBER		Total Invoice Amount
FREIGHT_AMOUNT	NUMBER		Freight Amount
PAYMENT_TERMS_NAME	VARCHAR2	(50)	Payment Terms Name
COMMENTS	VARCHAR2	(4000)	Comments
PACKING_SLIP	VARCHAR2	(25)	Packing Slip
CARRIER_EQUIPMENT	VARCHAR2	(10)	Carrier Equipment
CARRIER_METHOD	VARCHAR2	(2)	Carrier Method
HAZARD_CLASS	VARCHAR2	(4)	Hazard Class
HAZARD_CODE	VARCHAR2	(1)	Hazard Code
HAZARD_DESCRIPTION	VARCHAR2	(80)	Hazard Description
PACKAGING_CODE	VARCHAR2	(5)	Packaging Code
RECEIPT_NUM	VARCHAR2	(30)	Receipt Number
LOCATION_CODE	VARCHAR2	(60)	Location Code
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	(3)	Ship-To Organization Code
SPECIAL_HANDLING_CODE	VARCHAR2	(3)	Special Handling Code
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
VENDOR_ID	NUMBER		Vendor Identifier
VENDOR_NUM	VARCHAR2	(30)	Vendor Number
VENDOR_SITE_CODE	VARCHAR2	(35)	Vendor Site Code
VENDOR_SITE_ID	NUMBER		Vendor Site Identifier
TAR_WEIGHT	NUMBER		Tar Weight
TAR_WEIGHT_UOM_CODE	VARCHAR2	(3)	Tar Weight Unit Of Measure Code
NET_WEIGHT	NUMBER		Net Weight
NET_WEIGHT_UOM_CODE	VARCHAR2	(3)	Net weight Unit Of Measure Code
GROSS_WEIGHT	NUMBER		Gross Weight
GROSS_WEIGHT_UOM_CODE	VARCHAR2	(3)	Gross Weight Unit Of Measure Code
USGGL_TRANSACTION_CODE	VARCHAR2	(30)	USGGL Transaction Code
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
CONVERSION_RATE	NUMBER		Conversion Rate
CONVERSION_RATE_DATE	DATE		Conversion Rate Date
CONVERSION_RATE_TYPE	VARCHAR2	(30)	Conversion Rate Type
INVOICE_STATUS_CODE	VARCHAR2	(25)	Invoice Status Code
TAX_NAME	VARCHAR2	(50)	Tax Name
TAX_AMOUNT	NUMBER		Tax Amount
SHIP_TO_ORGANIZATION_ID	NUMBER		Ship-To Organization Identifier
HEADER_ID	NUMBER		ASN Header Identifier
ASN_TYPE	VARCHAR2	(25)	ASN Type
REMIT_TO_SITE_ID	NUMBER		Remit To Site Id

Query Text

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


SELECT SHIPMENT_NUM
,      SHIPPED_DATE
,      EXPECTED_RECEIPT_DATE
,      FREIGHT_TERMS
,      FREIGHT_CARRIER_CODE
,      FREIGHT_BILL_NUMBER
,      NUM_OF_CONTAINERS
,      BILL_OF_LADING
,      WAYBILL_AIRBILL_NUM
,      INVOICE_NUM
,      INVOICE_DATE
,      TOTAL_INVOICE_AMOUNT
,      FREIGHT_AMOUNT
,      PAYMENT_TERMS_NAME
,      COMMENTS
,      PACKING_SLIP
,      CARRIER_EQUIPMENT
,      CARRIER_METHOD
,      HAZARD_CLASS
,      HAZARD_CODE
,      HAZARD_DESCRIPTION
,      PACKAGING_CODE
,      RECEIPT_NUM
,      LOCATION_CODE
,      SHIP_TO_ORGANIZATION_CODE
,      SPECIAL_HANDLING_CODE
,      VENDOR_NAME
,      VENDOR_ID
,      VENDOR_NUM
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      TAR_WEIGHT
,      TAR_WEIGHT_UOM_CODE
,      NET_WEIGHT
,      NET_WEIGHT_UOM_CODE
,      GROSS_WEIGHT
,      GROSS_WEIGHT_UOM_CODE
,      USGGL_TRANSACTION_CODE
,      CURRENCY_CODE
,      CONVERSION_RATE
,      CONVERSION_RATE_DATE
,      CONVERSION_RATE_TYPE
,      INVOICE_STATUS_CODE
,      TAX_NAME
,      TAX_AMOUNT
,      SHIP_TO_ORGANIZATION_ID
,      HEADER_ID
,      ASN_TYPE
,      REMIT_TO_SITE_ID
FROM APPS.POS_HEADERS_V;

Dependencies

[top of page]

APPS.POS_HEADERS_V references the following:

APPS: AP_TERMS_VL; FND_GLOBAL - show dependent code; HR_LOCATIONS_ALL_TL; HZ_LOCATIONS; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_HEADERS_INTERFACE; RCV_SHIPMENT_HEADERS; RCV_TRANSACTIONS_INTERFACE

APPS.POS_HEADERS_V is referenced by following:

APPS: POS_ASN_NOTIF - show dependent code