[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_RECEIVING_TXN_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POA_EDW_RECEIVING_TXN_FCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_ID | NUMBER | |||
VIEW_ID | NUMBER | |||
RCV_TXN_PK | VARCHAR2 | (71) | ||
INSTANCE_FK | VARCHAR2 | (30) | ||
TXN_TYPE_FK | VARCHAR2 | (49) | ||
ITEM_REVISION_FK | VARCHAR2 | (4000) | ||
PO_LINE_TYPE_FK | VARCHAR2 | (25) | Yes | |
EDW_BASE_UOM_FK | VARCHAR2 | (4000) | ||
EDW_UOM_FK | VARCHAR2 | (4000) | ||
RECEIPT_SOURCE_FK | VARCHAR2 | (49) | ||
SUPPLIER_SITE_FK | VARCHAR2 | (4000) | ||
SUP_SITE_GEOG_FK | VARCHAR2 | (223) | ||
DESTIN_TYPE_FK | VARCHAR2 | (49) | ||
RCV_DEL_TO_ORG_FK | VARCHAR2 | (4000) | ||
RCV_LOCATION_FK | VARCHAR2 | (4000) | ||
DELIV_LOCATION_FK | VARCHAR2 | (4000) | ||
LOCATOR_FK | VARCHAR2 | (4000) | ||
BUYER_FK | VARCHAR2 | (4000) | ||
DELIVER_TO_FK | VARCHAR2 | (4000) | ||
TXN_DATE_FK | VARCHAR2 | (4000) | ||
TXN_CREAT_FK | VARCHAR2 | (4000) | ||
SHIPPED_TO_DATE_FK | VARCHAR2 | (4000) | ||
EXPCT_RCV_DATE_FK | VARCHAR2 | (4000) | ||
PROMISED_DATE_FK | VARCHAR2 | (4000) | ||
NEED_BY_DATE_FK | VARCHAR2 | (4000) | ||
LST_ACCPT_DATE_FK | VARCHAR2 | (4000) | ||
SRC_CREAT_DATE_FK | VARCHAR2 | (4000) | ||
PARNT_TXN_DATE_FK | VARCHAR2 | (4000) | ||
AP_TERMS_FK | VARCHAR2 | (73) | ||
RCV_ROUTING_FK | VARCHAR2 | (96) | ||
SUBST_UNORD_FK | VARCHAR2 | (50) | ||
PARNT_TXN_TYPE_FK | VARCHAR2 | (49) | ||
FREIGHT_TERMS_FK | VARCHAR2 | (43) | ||
INSPECT_STATUS_FK | VARCHAR2 | (46) | ||
INSPECT_QUAL_FK | VARCHAR2 | (45) | ||
RECEIVE_EXCEP_FK | VARCHAR2 | (12) | ||
USER_ENTERED_FK | VARCHAR2 | (12) | ||
TXN_REASON_FK | VARCHAR2 | (45) | ||
TXN_CUR_CODE_FK | VARCHAR2 | (15) | ||
PURCHASE_CLASS_CODE_FK | VARCHAR2 | (4000) | ||
SUPPLIER_ITEM_NUM_FK | VARCHAR2 | (4000) | ||
QTY_TXN | VARCHAR2 | (40) | ||
QTY_TXN_NET | VARCHAR2 | (40) | ||
QTY_RECEIVED | VARCHAR2 | (40) | ||
QTY_ACCEPT | VARCHAR2 | (40) | ||
QTY_REJECT | VARCHAR2 | (40) | ||
QTY_RETURN_TO_VENDOR | VARCHAR2 | (40) | ||
QTY_RETURN_TO_RECEIVING | VARCHAR2 | (40) | ||
QTY_DELIVER | VARCHAR2 | (40) | ||
QTY_TRANSFER | VARCHAR2 | (40) | ||
PRICE_T | NUMBER | |||
PRICE_G | NUMBER | |||
NUM_DAYS_TO_FULL_DEL | NUMBER | |||
SHIPMENT_NUM | VARCHAR2 | (30) | ||
INVOICE_NUM | VARCHAR2 | (50) | ||
RECEIPT_NUM_INST | VARCHAR2 | (71) | ||
SOURCE_TXN_NUMBER | VARCHAR2 | (20) | Yes | |
VENDOR_LOT_NUM | VARCHAR2 | (30) | ||
RMA_REFERENCE | VARCHAR2 | (30) | ||
TXN_COMMENTS | VARCHAR2 | (240) | ||
SHIP_HDR_COMMENTS | VARCHAR2 | (4000) | ||
WAY_AIRBILL_NUM | VARCHAR2 | (20) | ||
BILL_OF_LADING | VARCHAR2 | (25) | ||
PACKING_SLIP | VARCHAR2 | (25) | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
DUNS_FK | VARCHAR2 | (0) | ||
UNSPSC_FK | VARCHAR2 | (0) | ||
SIC_CODE_FK | VARCHAR2 | (0) | ||
PO_DISTRIBUTION_ID | NUMBER | po_distribution_id | ||
USER_ATTRIBUTE1 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE2 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE3 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE4 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE5 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE6 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE7 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE8 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE9 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE10 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE11 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE12 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE13 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE14 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE15 | VARCHAR2 | (0) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
USER_FK1 | CHAR | (6) | ||
USER_FK2 | CHAR | (6) | ||
USER_FK3 | CHAR | (6) | ||
USER_FK4 | CHAR | (6) | ||
USER_FK5 | CHAR | (6) |
Cut, paste (and edit) the following text to query this object:
SELECT SEQ_ID
, VIEW_ID
, RCV_TXN_PK
, INSTANCE_FK
, TXN_TYPE_FK
, ITEM_REVISION_FK
, PO_LINE_TYPE_FK
, EDW_BASE_UOM_FK
, EDW_UOM_FK
, RECEIPT_SOURCE_FK
, SUPPLIER_SITE_FK
, SUP_SITE_GEOG_FK
, DESTIN_TYPE_FK
, RCV_DEL_TO_ORG_FK
, RCV_LOCATION_FK
, DELIV_LOCATION_FK
, LOCATOR_FK
, BUYER_FK
, DELIVER_TO_FK
, TXN_DATE_FK
, TXN_CREAT_FK
, SHIPPED_TO_DATE_FK
, EXPCT_RCV_DATE_FK
, PROMISED_DATE_FK
, NEED_BY_DATE_FK
, LST_ACCPT_DATE_FK
, SRC_CREAT_DATE_FK
, PARNT_TXN_DATE_FK
, AP_TERMS_FK
, RCV_ROUTING_FK
, SUBST_UNORD_FK
, PARNT_TXN_TYPE_FK
, FREIGHT_TERMS_FK
, INSPECT_STATUS_FK
, INSPECT_QUAL_FK
, RECEIVE_EXCEP_FK
, USER_ENTERED_FK
, TXN_REASON_FK
, TXN_CUR_CODE_FK
, PURCHASE_CLASS_CODE_FK
, SUPPLIER_ITEM_NUM_FK
, QTY_TXN
, QTY_TXN_NET
, QTY_RECEIVED
, QTY_ACCEPT
, QTY_REJECT
, QTY_RETURN_TO_VENDOR
, QTY_RETURN_TO_RECEIVING
, QTY_DELIVER
, QTY_TRANSFER
, PRICE_T
, PRICE_G
, NUM_DAYS_TO_FULL_DEL
, SHIPMENT_NUM
, INVOICE_NUM
, RECEIPT_NUM_INST
, SOURCE_TXN_NUMBER
, VENDOR_LOT_NUM
, RMA_REFERENCE
, TXN_COMMENTS
, SHIP_HDR_COMMENTS
, WAY_AIRBILL_NUM
, BILL_OF_LADING
, PACKING_SLIP
, LAST_UPDATE_DATE
, CREATION_DATE
, DUNS_FK
, UNSPSC_FK
, SIC_CODE_FK
, PO_DISTRIBUTION_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5
FROM APPS.POA_EDW_RECEIVING_TXN_FCV;
|
|
|