[Home] [Help] [Dependency Information]
Object Name: | POA_DBI_RTX_F_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View based on Receiving Transactions fact
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | RCV Transaction Id | |
TRANSACTION_TYPE | VARCHAR2 | (25) | Yes | Transaction Type |
PARENT_TRANSACTION_TYPE | VARCHAR2 | (25) | Parent Transaction Type | |
GRP_TXN_DATE | DATE | Group Transaction Date | ||
RECEIVE_TXN_DATE | DATE | Receive Transaction Date | ||
SUPPLIER_ID | NUMBER | Supplier Id | ||
SUPPLIER_SITE_ID | NUMBER | Supplier Site Id | ||
CREATION_OPERATING_UNIT_ID | NUMBER | Creation Operating Unit Id | ||
RECEIVING_ORG_ID | NUMBER | Receiving Organization Id | ||
REASON_ID | NUMBER | Reason Id | ||
TRANSACTION_DATE | DATE | Yes | Transaction Date | |
RCV_CREATION_DATE | DATE | Yes | Receive Creation Date | |
QUANTITY | NUMBER | Quantity | ||
FUNC_CUR_CODE | VARCHAR2 | (15) | Functional Currency Code | |
GLOBAL_CUR_CONV_RATE | NUMBER | Currency Conversion Rate between Functional Currency and Global Currency | ||
LINE_LOCATION_ID | NUMBER | PO Shipment Id | ||
SHIPMENT_HEADER_ID | NUMBER | Yes | Receipt Shipment Header Id | |
SHIPMENT_LINE_ID | NUMBER | Yes | Receipt Shipment Line Id | |
ASN_TYPE | VARCHAR2 | (25) | ASN Type | |
RECEIPT_NUM | VARCHAR2 | (30) | Receipt Number | |
CREATED_BY | NUMBER | Yes | standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | standard WHO column | ||
CREATION_DATE | DATE | Yes | standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | standard WHO column | |
SGLOBAL_CUR_CONV_RATE | NUMBER | Currency Conversion Rate between Functional Currency and Secondary Global Currency | ||
SOURCE_DOC_QUANTITY | NUMBER | Source Document Quantity | ||
RECEIPT_EXISTS | VARCHAR2 | (1) | Receipt Exists Flag | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
SOURCE_DOCUMENT_CODE | VARCHAR2 | (25) | Source Document Code | |
SHIPPING_CONTROL | VARCHAR2 | (30) | Shipping Control | |
OE_ORDER_LINE_ID | NUMBER | Sales Order Line Id | ||
REQUISITION_LINE_ID | NUMBER | Requisition Line Id | ||
ROUTING_HEADER_ID | NUMBER | Routing Header Id | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
PRIMARY_QUANTITY | NUMBER | Primary Quantity | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary UOM Code | |
WMS_ENABLED_FLAG | VARCHAR2 | (1) | WMS Enabled Flag | |
WMS_GRP_TXN_DATE | DATE | WMS Group Transaction Date | ||
DROPSHIP_TYPE_CODE | NUMBER | Dropship Type Code | ||
INV_TRANSACTION_ID | NUMBER | Inventory Transaction Id |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, TRANSACTION_TYPE
, PARENT_TRANSACTION_TYPE
, GRP_TXN_DATE
, RECEIVE_TXN_DATE
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, CREATION_OPERATING_UNIT_ID
, RECEIVING_ORG_ID
, REASON_ID
, TRANSACTION_DATE
, RCV_CREATION_DATE
, QUANTITY
, FUNC_CUR_CODE
, GLOBAL_CUR_CONV_RATE
, LINE_LOCATION_ID
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, ASN_TYPE
, RECEIPT_NUM
, CREATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, SGLOBAL_CUR_CONV_RATE
, SOURCE_DOC_QUANTITY
, RECEIPT_EXISTS
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, SOURCE_DOCUMENT_CODE
, SHIPPING_CONTROL
, OE_ORDER_LINE_ID
, REQUISITION_LINE_ID
, ROUTING_HEADER_ID
, INVENTORY_ITEM_ID
, PRIMARY_QUANTITY
, PRIMARY_UOM_CODE
, WMS_ENABLED_FLAG
, WMS_GRP_TXN_DATE
, DROPSHIP_TYPE_CODE
, INV_TRANSACTION_ID
FROM APPS.POA_DBI_RTX_F_V;
APPS.POA_DBI_RTX_F_V is not referenced by any database object
|
|
|