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

VIEW: APPS.EDW_POA_SPIM_SPLRITEM_LCV

Object Details
Object Name: EDW_POA_SPIM_SPLRITEM_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.EDW_POA_SPIM_SPLRITEM_LCV
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
SUPPLIER_ITEM_PK VARCHAR2 (282)
ALL_FK CHAR (3)
SUPPLIER_SITE_ITEM_DP VARCHAR2 (282)
SUPPLIER_ITEM_DP VARCHAR2 (266)
NAME VARCHAR2 (25)
SUPPLIER_SITE_CODE VARCHAR2 (15) Yes
SUPPLIER_NAME VARCHAR2 (240)
INSTANCE VARCHAR2 (30)
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
USER_ATTRIBUTE1 VARCHAR2 (0)
USER_ATTRIBUTE2 VARCHAR2 (0)
USER_ATTRIBUTE3 VARCHAR2 (0)
USER_ATTRIBUTE4 VARCHAR2 (0)
USER_ATTRIBUTE5 VARCHAR2 (0)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUPPLIER_ITEM_PK
,      ALL_FK
,      SUPPLIER_SITE_ITEM_DP
,      SUPPLIER_ITEM_DP
,      NAME
,      SUPPLIER_SITE_CODE
,      SUPPLIER_NAME
,      INSTANCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_POA_SPIM_SPLRITEM_LCV;

Dependencies

[top of page]

APPS.EDW_POA_SPIM_SPLRITEM_LCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.EDW_POA_SPIM_SPLRITEM_LCV is referenced by following:

SchemaAPPS
ViewEDW_POA_SPLRITEM_MPV