DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.POA_DBI_RTX_F_V

Object Details
Object Name: POA_DBI_RTX_F_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


View based on Receiving Transactions fact


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.POA_DBI_RTX_F_V references the following:

SchemaAPPS
SynonymPOA_DBI_RTX_F

APPS.POA_DBI_RTX_F_V is not referenced by any database object