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: ViewICX.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

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

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 (30)
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:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymMTL_UNITS_OF_MEASURE
SynonymOE_ORDER_HEADERS
SynonymOE_ORDER_LINES
PL/SQL PackagePOR_RCV_TRANSACTION_SV - show dependent code
PL/SQL PackagePO_CORE_S2 - show dependent code
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES
SynonymPO_SYSTEM_PARAMETERS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
APPS.POR_CONFIRM_INTERNAL_RECEIPT_V is referenced by following:

SchemaAPPS
Package BodyPORCPTWF - show dependent code