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

Object Details

Object Name:	POR_CONFIRM_INTERNAL_RECEIPT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.POR_CONFIRM_INTERNAL_RECEIPT_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

View to query requisition items that are from source type 'INVENTORY' and is valid to be received.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RECEIPT_DATE	DATE			Receipt date
REQUESTOR_ID	NUMBER	(9)	Yes	Requestor ID
PO_HEADER_ID	NUMBER		Yes	Purchase Order header ID
PO_NUMBER	VARCHAR2	(0)		Purchase Order Number
PO_LINE_ID	NUMBER			Purchase Order line ID
PO_LINE_LOCATION_ID	NUMBER			Purchase Order line location ID
PO_RELEASE_NUMBER	NUMBER			Purchase Order release number
PO_LINE_NUMBER	NUMBER			Purchase Order line number
PO_SHIPMENT_NUMBER	NUMBER			Purchase Order Shipment Number
TO_ORGANIZATION_ID	NUMBER			ID of the organization deleivered to
ITEM_ID	NUMBER			ID of the item
PRIMARY_UOM	VARCHAR2	(25)		Primary Unit of Measure
PRIMARY_UOM_CLASS	VARCHAR2	(10)		Primary Unit of Measure class
QUANTITY_DELIVERED	NUMBER			Delivered quantity
EXPECTED_RECEIPT_QTY	NUMBER			Expected Receipt Quantity
ITEM_DESCRIPTION	VARCHAR2	(240)	Yes	Description of the item
SHIP_TO_LOCATION_ID	NUMBER		Yes	ID of the location shipped to
VENDOR_ID	NUMBER			Vendor ID
SOURCE	VARCHAR2	(240)		Source code
VENDOR_SITE_ID	NUMBER			ID of the vendor site
SUPPLIER_SITE	VARCHAR2	(0)		Supplier Site
NEED_BY_DATE	DATE			Need By date
PROMISED_DATE	DATE			Promised date
EXPECTED_RECEIPT_DATE	DATE			Expected receipt date
ORDERED_QTY	NUMBER			Quantity ordered
ORDERED_UOM	VARCHAR2	(25)		Unit of measure of order
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Translation Code
PO_DISTRIBUTION_ID	NUMBER			Purchase Order Distribution ID
DELIVER_TO_LOCATION_ID	NUMBER		Yes	ID of deliver to location
REQ_DISTRIBUTION_ID	NUMBER			Requisition Distribution ID
PO_DISTRIBUTION_NUM	NUMBER			Purchase Order Distribution Number
VENDOR_PRODUCT_NUM	VARCHAR2	(0)		Vendor Product Number
PO_NUM_REL_NUM	VARCHAR2	(40)		Release Number of Purchase order
ORDER_NUMBER	NUMBER		Yes	Order Number
REQ_LINE_ID	NUMBER		Yes	Requisition Line ID
RCV_SHIPMENT_NUMBER	VARCHAR2	(4000)		Shipment Number
ORDER_TYPE_CODE	CHAR	(3)		Code of Order Type
SO_HEADER_ID	NUMBER		Yes	SO Header ID
SO_LINE_NUMBER	NUMBER		Yes	SO Line Number
REQUISITION_HEADER_ID	NUMBER		Yes	Requisition Header ID
REQUISITION_LINE_ID	NUMBER		Yes	Requisition Line ID
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination Type Code
RECEIPT_REQUIRED_FLAG	CHAR	(1)		Receipt Required flag
WAYBILL_AIRBILL_NUM	VARCHAR2	(20)		Number of Waybill, Airbill
PACKING_SLIP	VARCHAR2	(25)		Packing Slip
COMMENTS	VARCHAR2	(4000)		Comments
REQUISITION_CREATION_DATE	DATE			Requisition creation date
REQ_NUMBER	VARCHAR2	(20)	Yes	Requisition number
CURRENCY_CODE	VARCHAR2	(4000)		Code of currency
UNIT_PRICE	NUMBER			Unit price

Query Text

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


SELECT RECEIPT_DATE
,      REQUESTOR_ID
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_RELEASE_NUMBER
,      PO_LINE_NUMBER
,      PO_SHIPMENT_NUMBER
,      TO_ORGANIZATION_ID
,      ITEM_ID
,      PRIMARY_UOM
,      PRIMARY_UOM_CLASS
,      QUANTITY_DELIVERED
,      EXPECTED_RECEIPT_QTY
,      ITEM_DESCRIPTION
,      SHIP_TO_LOCATION_ID
,      VENDOR_ID
,      SOURCE
,      VENDOR_SITE_ID
,      SUPPLIER_SITE
,      NEED_BY_DATE
,      PROMISED_DATE
,      EXPECTED_RECEIPT_DATE
,      ORDERED_QTY
,      ORDERED_UOM
,      USSGL_TRANSACTION_CODE
,      PO_DISTRIBUTION_ID
,      DELIVER_TO_LOCATION_ID
,      REQ_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUM
,      VENDOR_PRODUCT_NUM
,      PO_NUM_REL_NUM
,      ORDER_NUMBER
,      REQ_LINE_ID
,      RCV_SHIPMENT_NUMBER
,      ORDER_TYPE_CODE
,      SO_HEADER_ID
,      SO_LINE_NUMBER
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      DESTINATION_TYPE_CODE
,      RECEIPT_REQUIRED_FLAG
,      WAYBILL_AIRBILL_NUM
,      PACKING_SLIP
,      COMMENTS
,      REQUISITION_CREATION_DATE
,      REQ_NUMBER
,      CURRENCY_CODE
,      UNIT_PRICE
FROM APPS.POR_CONFIRM_INTERNAL_RECEIPT_V;

Dependencies

[top of page]

APPS.POR_CONFIRM_INTERNAL_RECEIPT_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; MTL_UNITS_OF_MEASURE; OE_ORDER_HEADERS; OE_ORDER_LINES; POR_RCV_TRANSACTION_SV - show dependent code; PO_CORE_S2 - show dependent code; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; PO_SYSTEM_PARAMETERS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES

APPS.POR_CONFIRM_INTERNAL_RECEIPT_V is referenced by following:

APPS: PORCPTWF - show dependent code