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

VIEW: APPS.POA_RTX_BS_V

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


Receipt/Return/Rejection details


[View Source]

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

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;

Dependencies

[top of page]

APPS.POA_RTX_BS_V references the following:

SchemaAPPS
TablePOA_DBI_PLL_MV
SynonymPOA_DBI_RTX_F
TablePOA_RTX_BS_J_MV
SynonymRCV_TRANSACTIONS

APPS.POA_RTX_BS_V is not referenced by any database object