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

VIEW: APPS.POABV_EDW_RECEIVING_TXN_FCV

Object Details
Object Name: POABV_EDW_RECEIVING_TXN_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POABV_EDW_RECEIVING_TXN_FCV
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns
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

rcv.po_distribution_id
_DF:PO_HDR:_EDW CHAR (21)
_DF:PO_LINES:_EDW CHAR (19)
_DF:PO_RCV:_EDW CHAR (29)
Query Text

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
,      _DF:PO_HDR:_EDW
,      _DF:PO_LINES:_EDW
,      _DF:PO_RCV:_EDW
FROM APPS.POABV_EDW_RECEIVING_TXN_FCV;

Dependencies

[top of page]

APPS.POABV_EDW_RECEIVING_TXN_FCV references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_GEOGRAPHY_PKG - show dependent code
PL/SQL PackageEDW_HR_PERSON_PKG - show dependent code
PL/SQL PackageEDW_ITEMS_PKG - show dependent code
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_LOOKUP_PKG - show dependent code
PL/SQL PackageEDW_MTL_INVENTORY_LOC_PKG - show dependent code
PL/SQL PackageEDW_ORGANIZATION_PKG - show dependent code
PL/SQL PackageEDW_SUPPLIER_ITEM_PKG - show dependent code
PL/SQL PackageEDW_TIME_PKG - show dependent code
PL/SQL PackageEDW_TRD_PARTNER_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
ViewGL_SETS_OF_BOOKS
SynonymHR_LOCATIONS_ALL
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_UNITS_OF_MEASURE
PL/SQL PackagePOA_CUSTOMIZATION_PKG - show dependent code
SynonymPOA_EDW_RCV_TXNS_INC
PL/SQL PackagePOA_EDW_RCV_TXNS_PKG - show dependent code
SynonymPO_DOC_STYLE_HEADERS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
ViewRCV_ROUTING_HEADERS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS
APPS.POABV_EDW_RECEIVING_TXN_FCV is referenced by following:

SchemaAPPS
ViewPOA_EDW_RECEIVING_TXN_FCV