[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
|
|
|