[Home] [Help] [Dependency Information]
Object Name: | POA_RTX_BS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Receipt/Return/Rejection details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | Transaction Identifier | |
COMMODITY_ID | NUMBER | Commodity Identifier | ||
CATEGORY_ID | NUMBER | Category Identifier | ||
PO_ITEM_ID | NUMBER | Yes | PO Item Identifier | |
ORG_ID | NUMBER | Operating Unit Identifier | ||
SUPPLIER_ID | NUMBER | Supplier Identifier | ||
SUPPLIER_SITE_ID | NUMBER | Supplier Site Identifier | ||
BUYER_ID | NUMBER | Yes | Buyer Identifier | |
RECEIVING_ORG_ID | NUMBER | Receiving Organization Identifier | ||
REASON_ID | NUMBER | Reason Identifier | ||
BASE_UOM | VARCHAR2 | (25) | Base UOM | |
TRANSACTION_TYPE | VARCHAR2 | (25) | Yes | Transaction Type |
ENT_QTR_ID | NUMBER | Enterprise Quarter Identifier | ||
ENT_PERIOD_ID | NUMBER | Enterprise Period Identifier | ||
WEEK_ID | NUMBER | Yes | Week Identifier | |
DAY_ID | NUMBER | Yes | Day Identifier | |
MX_ID | NUMBER | Yes | Multiplexer Identifier | |
QUANTITY | NUMBER | Quantity | ||
AMOUNT_B | NUMBER | Receipt Amount (Functional Currency) | ||
AMOUNT_G | NUMBER | Receipt Amount (Global Currency) | ||
AMOUNT_SG | NUMBER | Receipt Amount (Secondary Global Currency) | ||
AMT_AFTERDUE_B | NUMBER | Amount Afterdue (Functional Currency) | ||
AMT_AFTERDUE_G | NUMBER | Amount Afterdue (Global Currency) | ||
AMT_AFTERDUE_SG | NUMBER | Amount Afterdue (Secondary Global Currency) | ||
AMT_BEFOREDUE_B | NUMBER | Amount Beforedue (Functional Currency) | ||
AMT_BEFOREDUE_G | NUMBER | Amount Beforedue (Global Currency) | ||
AMT_BEFOREDUE_SG | NUMBER | Amount Beforedue (Secondary Global Currency) | ||
AMT_EXPT_B | NUMBER | Exception Amount (Functional Currency) | ||
AMT_EXPT_G | NUMBER | Exception Amount (Global Currency) | ||
AMT_EXPT_SG | NUMBER | Exception Amount (Secondary Global Currency) | ||
AMT_INSPECTED_B | NUMBER | Inspected Amount (Functional Currency) | ||
AMT_INSPECTED_G | NUMBER | Inspected Amount (Global Currency) | ||
AMT_INSPECTED_SG | NUMBER | Inspected Amount (Secondary Global Currency) | ||
QTY_INTOL | NUMBER | Quantity In tolerance | ||
QTY_AFTERDUE | NUMBER | Quantity After due | ||
QTY_BEFOREDUE | NUMBER | Quantity Before Due | ||
NUM_DAYS_LATE | NUMBER | Number of Days Received Late | ||
NUM_DAYS_EARLY | NUMBER | Number of Days Received Early | ||
TRANSACTION_FLAG | VARCHAR2 | (16) | Transaction Flag | |
DROPSHIP_TYPE_CODE | NUMBER | Dropship Type Code | ||
PARENT_TRANSACTION_TYPE | VARCHAR2 | (25) | Parent Transaction Type | |
GRP_TXN_DATE | DATE | Group Transaction Date | ||
RECEIVE_TXN_DATE | DATE | Receive Transaction Date | ||
TRANSACTION_DATE | DATE | Yes | Transaction Date | |
RCV_CREATION_DATE | DATE | Yes | Receipt Creation Date | |
FUNC_CUR_CODE | VARCHAR2 | (15) | Functional Currency Code | |
GLOBAL_CUR_CONV_RATE | NUMBER | Global Currency Conversion Rate | ||
SGLOBAL_CUR_CONV_RATE | NUMBER | Secondary Global Currency Conversion Rate | ||
RECEIPT_NUM | VARCHAR2 | (30) | Receipt Number | |
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 | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
EXPECTED_DATE | DATE | Shipment Expected Date | ||
PRICE_OVERRIDE | NUMBER | PO Price | ||
MATCHING_BASIS | VARCHAR2 | (30) | Matching Basis | |
BASE_UOM_CONV_RATE | NUMBER | Base UOM Conversion Rate | ||
TRANSACTION_UOM | VARCHAR2 | (25) | Transaction UOM | |
LINE_LOCATION_ID | NUMBER | PO Shipment Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, COMMODITY_ID
, CATEGORY_ID
, PO_ITEM_ID
, ORG_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, BUYER_ID
, RECEIVING_ORG_ID
, REASON_ID
, BASE_UOM
, TRANSACTION_TYPE
, ENT_QTR_ID
, ENT_PERIOD_ID
, WEEK_ID
, DAY_ID
, MX_ID
, QUANTITY
, AMOUNT_B
, AMOUNT_G
, AMOUNT_SG
, AMT_AFTERDUE_B
, AMT_AFTERDUE_G
, AMT_AFTERDUE_SG
, AMT_BEFOREDUE_B
, AMT_BEFOREDUE_G
, AMT_BEFOREDUE_SG
, AMT_EXPT_B
, AMT_EXPT_G
, AMT_EXPT_SG
, AMT_INSPECTED_B
, AMT_INSPECTED_G
, AMT_INSPECTED_SG
, QTY_INTOL
, QTY_AFTERDUE
, QTY_BEFOREDUE
, NUM_DAYS_LATE
, NUM_DAYS_EARLY
, TRANSACTION_FLAG
, DROPSHIP_TYPE_CODE
, PARENT_TRANSACTION_TYPE
, GRP_TXN_DATE
, RECEIVE_TXN_DATE
, TRANSACTION_DATE
, RCV_CREATION_DATE
, FUNC_CUR_CODE
, GLOBAL_CUR_CONV_RATE
, SGLOBAL_CUR_CONV_RATE
, RECEIPT_NUM
, RECEIPT_EXISTS
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, SOURCE_DOCUMENT_CODE
, SHIPPING_CONTROL
, INVENTORY_ITEM_ID
, EXPECTED_DATE
, PRICE_OVERRIDE
, MATCHING_BASIS
, BASE_UOM_CONV_RATE
, TRANSACTION_UOM
, LINE_LOCATION_ID
FROM APPS.POA_RTX_BS_V;
APPS.POA_RTX_BS_V is not referenced by any database object
|
|
|