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_RECEIPT_HEADERS_V

Object Details

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

View Type

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

This View is used to display receipt information for all organizations , used for Receipts Inquiry in ISP

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RECEIPT_NUM	VARCHAR2	(30)		Receipt Number
RECEIPT_DATE	DATE		Yes	Receipt Date
SOURCE_TYPE	VARCHAR2	(25)	Yes	Source Type
SUPPLIER_ID	NUMBER			Supplier Identifier
SUPPLIER	VARCHAR2	(240)		Supplier
VENDOR_ID	NUMBER			Vendor Identifier
VENDOR	VARCHAR2	(240)		Vendor
SUPPLIER_SITE_ID	NUMBER			Supplier Site Identifier
SUPPLIER_SITE	VARCHAR2	(15)		Supplier Site
ORGANIZATION_ID	NUMBER			Organization Identifier
SOURCE_ORG	VARCHAR2	(240)		Source Organization
SHIPMENT_NUM	VARCHAR2	(30)		Shipment Number
SHIP_TO_LOCATION_ID	NUMBER			Ship-to Location Identifier
SHIP_TO_LOCATION	VARCHAR2	(60)		Ship-to Location
BILL_OF_LADING	VARCHAR2	(25)		Bill-of Lading
PACKING_SLIP	VARCHAR2	(25)		Packing Slip
SHIPPED_DATE	DATE			Shipped Date
FREIGHT_CARRIER_CODE	VARCHAR2	(25)		Freight Carrier Code
EXPECTED_RECEIPT_DATE	DATE			Expected Receipt Date
EMPLOYEE_ID	NUMBER	(9)		Employee Identifier
RECEIVER	VARCHAR2	(240)		Receiver
NUM_OF_CONTAINERS	NUMBER			Number of Containers
WAYBILL_AIRBILL_NUM	VARCHAR2	(30)		waybill Airbill Number
COMMENTS	VARCHAR2	(4000)		Comments
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		USSGL Transaction Code
GOVERNMENT_CONTEXT	VARCHAR2	(30)		Government Context
SHIPMENT_HEADER_ID	NUMBER		Yes	Shipment Header Identifier
SUPPLIER_URL	VARCHAR2	(150)		Supplier Url

Query Text

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


SELECT RECEIPT_NUM
,      RECEIPT_DATE
,      SOURCE_TYPE
,      SUPPLIER_ID
,      SUPPLIER
,      VENDOR_ID
,      VENDOR
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      ORGANIZATION_ID
,      SOURCE_ORG
,      SHIPMENT_NUM
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      BILL_OF_LADING
,      PACKING_SLIP
,      SHIPPED_DATE
,      FREIGHT_CARRIER_CODE
,      EXPECTED_RECEIPT_DATE
,      EMPLOYEE_ID
,      RECEIVER
,      NUM_OF_CONTAINERS
,      WAYBILL_AIRBILL_NUM
,      COMMENTS
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      SHIPMENT_HEADER_ID
,      SUPPLIER_URL
FROM APPS.POS_RECEIPT_HEADERS_V;

Dependencies

[top of page]

APPS.POS_RECEIPT_HEADERS_V references the following:

APPS: FND_GLOBAL - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_SECURITY - show dependent code; ORG_ORGANIZATION_DEFINITIONS; PER_ALL_PEOPLE_F; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_SHIPMENT_HEADERS

APPS.POS_RECEIPT_HEADERS_V is not referenced by any database object