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

Object Details

Object Name:	CSP_RECEIVE_HEADERS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
DOC_TYPE	VARCHAR2	(80)	Document Type
DOC_TYPE_CODE	VARCHAR2	(30)	Document Type Code
HEADER_ID	NUMBER		Header Identifier
DOCUMENT_NUMBER	VARCHAR2	(30)	Document Number
SOURCE_TYPE_CODE	VARCHAR2	(8)	Source Type Code
RECEIPT_SOURCE_CODE	VARCHAR2	(14)	Receipt Source Code
VENDOR_ID	NUMBER		Vendor Identifier
VENDOR_SITE_ID	NUMBER		Vendor Site Identifier
SHIP_TO_ORGANIZATION_ID	NUMBER		Ship To Organization Identifier
PO_SHIPMENT_NUM	NUMBER		PO Shipment Number
PO_HEADER_ID	NUMBER		PO Header Identifier
RCV_SHIPMENT_HEADER_ID	NUMBER		Receive Shipment Header Identifier
RCV_SHIPMENT_NUMBER	VARCHAR2	(30)	Receive Shipment Number
RECEIPT_NUMBER	VARCHAR2	(30)	Receipt Number
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	VARCHAR2	(0)	Employee identifier
NUM_OF_CONTAINERS	NUMBER		Number of containers
WAYBILL_AIRBILL_NUM	VARCHAR2	(20)	Waybill number
COMMENTS	VARCHAR2	(4000)	Comments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive Flexfield Structure Defining column
ATTRIBUTE1	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE2	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE3	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE4	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE5	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE6	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE7	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE8	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE9	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE10	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE11	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE12	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE13	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE14	VARCHAR2	(150)	Descriptive Flexfield Segment Column
ATTRIBUTE15	VARCHAR2	(150)	Descriptive Flexfield Segment Column
USSGL_TRANSACTION_CODE	VARCHAR2	(30)	USSGL Transaction Code
DESTINATION_SUBINVENTORY	VARCHAR2	(10)	Destination subinventory
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	(3)	Ship to organization code
VENDOR_NAME	VARCHAR2	(240)	Vendor name

Query Text

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


SELECT DOC_TYPE
,      DOC_TYPE_CODE
,      HEADER_ID
,      DOCUMENT_NUMBER
,      SOURCE_TYPE_CODE
,      RECEIPT_SOURCE_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      SHIP_TO_ORGANIZATION_ID
,      PO_SHIPMENT_NUM
,      PO_HEADER_ID
,      RCV_SHIPMENT_HEADER_ID
,      RCV_SHIPMENT_NUMBER
,      RECEIPT_NUMBER
,      BILL_OF_LADING
,      PACKING_SLIP
,      SHIPPED_DATE
,      FREIGHT_CARRIER_CODE
,      EXPECTED_RECEIPT_DATE
,      EMPLOYEE_ID
,      NUM_OF_CONTAINERS
,      WAYBILL_AIRBILL_NUM
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      USSGL_TRANSACTION_CODE
,      DESTINATION_SUBINVENTORY
,      SHIP_TO_ORGANIZATION_CODE
,      VENDOR_NAME
FROM APPS.CSP_RECEIVE_HEADERS_V;

Dependencies

[top of page]

APPS.CSP_RECEIVE_HEADERS_V references the following:

APPS: FND_LOOKUP_VALUES_VL; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; MTL_PARAMETERS; MTL_SUPPLY; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_REQUISITION_LINES_ALL; PO_VENDORS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES

APPS.CSP_RECEIVE_HEADERS_V is referenced by following:

APPS: CSFW_ORDER_PARTS - show dependent code