[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POA_DBI_RTX_F |
|---|---|
| Object Type: | TABLE |
| Owner: | POA |
| Subobject Name: | |
| Status: | VALID |
RCV Transactions base table - update and insert only
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| POA_DBI_RTX_F_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 TRANSACTION_ID
|
| POA_DBI_RTX_F_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
OE_ORDER_LINE_ID
|
| POA_DBI_RTX_F_N2 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
REQUISITION_LINE_ID
|
| 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 | Grouping Transaction Date | ||
| RECEIVE_TXN_DATE | DATE | Receiving transaction Date | ||
| SUPPLIER_ID | NUMBER | Supplier Id | ||
| SUPPLIER_SITE_ID | NUMBER | Supplier Site Id | ||
| BUYER_ID | NUMBER | |||
| CREATION_OPERATING_UNIT_ID | NUMBER | Creation Operating Unit Id | ||
| RECEIVING_ORG_ID | NUMBER | Receiving Organization Id | ||
| CATEGORY_ID | NUMBER | |||
| PO_ITEM_ID | NUMBER | |||
| REASON_ID | NUMBER | Reason Id | ||
| TRANSACTION_DATE | DATE | Yes | RCV Transaction Date | |
| RCV_CREATION_DATE | DATE | Yes | RCV Creation Date | |
| QUANTITY | NUMBER | Quantity in reporting UOM | ||
| QTY_AFTERDUE | NUMBER | |||
| QTY_BEFOREDUE | NUMBER | |||
| QTY_INTOL | NUMBER | |||
| BASE_UOM | VARCHAR2 | (25) | ||
| AMOUNT_B | NUMBER | |||
| AMT_AFTERDUE_B | NUMBER | |||
| AMT_BEFOREDUE_B | NUMBER | |||
| EXPECTED_DATE | DATE | |||
| NUM_DAYS_LATE | NUMBER | |||
| NUM_DAYS_EARLY | NUMBER | |||
| FUNC_CUR_CODE | VARCHAR2 | (15) | Functional Currency Code | |
| GLOBAL_CUR_CONV_RATE | NUMBER | Global currency conversion rate, from functional currency | ||
| LINE_LOCATION_ID | NUMBER | PO Line Location Id | ||
| SHIPMENT_HEADER_ID | NUMBER | Yes | Shipment Header Id | |
| SHIPMENT_LINE_ID | NUMBER | Yes | Shipment LIne Id | |
| ASN_TYPE | VARCHAR2 | (25) | ASN Type | |
| RECEIPT_NUM | VARCHAR2 | (30) | Receipt Number | |
| CREATED_BY | NUMBER | Yes | Created By | |
| LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
| CREATION_DATE | DATE | Yes | Creation Date | |
| LAST_UPDATED_BY | NUMBER | Yes | Last Updated By | |
| LAST_UPDATE_DATE | DATE | Yes | Last Updated Date | |
| SGLOBAL_CUR_CONV_RATE | NUMBER | Conversion Rate from Functional Currency to Secondary Global Currency | ||
| SOURCE_DOC_QUANTITY | NUMBER | Source Document Quantity | ||
| RECEIPT_EXISTS | VARCHAR2 | (1) | Flag to check if Receipt Exists | |
| 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 Flag | |
| 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
, BUYER_ID
, CREATION_OPERATING_UNIT_ID
, RECEIVING_ORG_ID
, CATEGORY_ID
, PO_ITEM_ID
, REASON_ID
, TRANSACTION_DATE
, RCV_CREATION_DATE
, QUANTITY
, QTY_AFTERDUE
, QTY_BEFOREDUE
, QTY_INTOL
, BASE_UOM
, AMOUNT_B
, AMT_AFTERDUE_B
, AMT_BEFOREDUE_B
, EXPECTED_DATE
, NUM_DAYS_LATE
, NUM_DAYS_EARLY
, 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 POA.POA_DBI_RTX_F;
POA.POA_DBI_RTX_F does not reference any database object
POA.POA_DBI_RTX_F is referenced by following:
APPS
OPI_WMS_002_MV
POA_DBI_RTX_F
POA_RTX_BS_J_MV
|
|
|
|