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

VIEW: APPS.OP_GNRC_ITM_VW1

Object Details
Object Name: OP_GNRC_ITM_VW1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGML.OP_GNRC_ITM_VW1
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 Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
GENERIC_ITEM VARCHAR2 (32) Yes Customer item number. Item number that customer uses.
CUST_NO VARCHAR2 (4000)
GEMMS customer number to whom the customer item number is from
ITEM_NO VARCHAR2 (32) Yes GEMMS item number which refers to the item number of the customer.
DELETE_MARK NUMBER (5) Yes
Query Text

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


SELECT GENERIC_ITEM
,      CUST_NO
,      ITEM_NO
,      DELETE_MARK
FROM APPS.OP_GNRC_ITM_VW1;

Dependencies

[top of page]

APPS.OP_GNRC_ITM_VW1 references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymIC_ITEM_MST
SynonymOP_CUST_MST
SynonymOP_GNRC_ITM

APPS.OP_GNRC_ITM_VW1 is not referenced by any database object