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


VIEW: APPS.MTL_DEFAULT_SETS_VIEW

Object Details
Object Name: MTL_DEFAULT_SETS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_DEFAULT_SETS_VIEW
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
CATEGORY_SET_ID NUMBER
Yes Category set identifier
CATEGORY_SET_NAME VARCHAR2 (30) Yes Category set name
DESCRIPTION VARCHAR2 (240)
Category set description
STRUCTURE_ID NUMBER
Yes Flexfield structure identifier
VALIDATE_FLAG VARCHAR2 (1) Yes Flag indicating category validation is required
FUNCTIONAL_AREA_ID NUMBER
Yes Category set functional area identifier
Query Text

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


SELECT CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      DESCRIPTION
,      STRUCTURE_ID
,      VALIDATE_FLAG
,      FUNCTIONAL_AREA_ID
FROM APPS.MTL_DEFAULT_SETS_VIEW;

Dependencies

[top of page]

APPS.MTL_DEFAULT_SETS_VIEW references the following:

SchemaAPPS
SynonymMTL_CATEGORY_SETS_B
SynonymMTL_CATEGORY_SETS_TL
SynonymMTL_DEFAULT_CATEGORY_SETS
APPS.MTL_DEFAULT_SETS_VIEW is referenced by following:

SchemaAPPS
Package BodyAP_IMPORT_INVOICES_PKG - show dependent code
PL/SQL PackageAP_IMPORT_INVOICES_PKG - show dependent code
Package BodyAP_MATCHING_UTILS_PKG - show dependent code
Package BodyCSD_RECEIVE_UTIL - show dependent code
Package BodyCSP_PARTS_ORDER - show dependent code
Package BodyCST_PERENDACCRUALS_PVT - show dependent code
Package BodyCS_REPORTS_PACKAGE - show dependent code
Package BodyCTO_AUTO_PROCURE_PK - show dependent code
Package BodyE_CHANGES_INT_PKG - show dependent code
Package BodyFLM_KANBAN_PLANNING_UTIL - show dependent code
Package BodyICX_CAT_UTIL_PVT - show dependent code
Package BodyICX_ITEM_DIAG_PVT - show dependent code
Package BodyICX_POR_EXTRACTOR - show dependent code
Package BodyICX_POR_EXT_CLASS - show dependent code
Package BodyICX_POR_EXT_DIAG - show dependent code
Package BodyICX_POR_EXT_ITEM - show dependent code
Package BodyICX_POR_EXT_PURGE - show dependent code
Package BodyICX_POR_EXT_TEST - show dependent code
Package BodyICX_REQ_CATEGORIES - show dependent code
ViewICX_REQ_CATEGORIES_V
Package BodyICX_REQ_SEARCH - show dependent code
Package BodyICX_REQ_SPECIAL_ORD - show dependent code
Package BodyINV_INVARPSL_XMLP_PKG - show dependent code
Package BodyINV_LOT_SERIAL_DATE_EVENT_PKG - show dependent code
Package BodyMRP_MRPRPRSC_XMLP_PKG - show dependent code
Package BodyMRP_MRPRPSST_XMLP_PKG - show dependent code
Package BodyPON_NEGOTIATION_PUBLISH_PVT - show dependent code
Package BodyPON_VALIDATE_ITEM_PRICES_INT - show dependent code
Package BodyPO_AUTOSOURCE_SV - show dependent code
Package BodyPO_COPYDOC_S3 - show dependent code
Package BodyPO_COPYDOC_SUB - show dependent code
Package BodyPO_CORE_S - show dependent code
Package BodyPO_CREATE_REQUISITION_SV - show dependent code
Package BodyPO_DOCUMENT_ACTION_CHECK - show dependent code
Package BodyPO_POXAGLST_XMLP_PKG - show dependent code
Package BodyPO_POXBLREL_XMLP_PKG - show dependent code
Package BodyPO_POXCONST_XMLP_PKG - show dependent code
Package BodyPO_POXCORIT_XMLP_PKG - show dependent code
Package BodyPO_POXDETIT_XMLP_PKG - show dependent code
Package BodyPO_POXDLPDT_XMLP_PKG - show dependent code
Package BodyPO_POXKIAGN_XMLP_PKG - show dependent code
Package BodyPO_POXPOABP_XMLP_PKG - show dependent code
Package BodyPO_POXPOBPS_XMLP_PKG - show dependent code
Package BodyPO_POXPOCOM_XMLP_PKG - show dependent code
Package BodyPO_POXPOEDR_XMLP_PKG - show dependent code
Package BodyPO_POXPOPAA_XMLP_PKG - show dependent code
Package BodyPO_POXPOSMH_XMLP_PKG - show dependent code
Package BodyPO_POXPOSTD_XMLP_PKG - show dependent code
Package BodyPO_POXPRIPR_XMLP_PKG - show dependent code
Package BodyPO_POXPRREQ_XMLP_PKG - show dependent code
Package BodyPO_POXQTQAR_XMLP_PKG - show dependent code
Package BodyPO_POXQUAPR_XMLP_PKG - show dependent code
Package BodyPO_POXRFRAR_XMLP_PKG - show dependent code
Package BodyPO_POXRQEXP_XMLP_PKG - show dependent code
Package BodyPO_POXRQOBO_XMLP_PKG - show dependent code
Package BodyPO_POXRQRCO_XMLP_PKG - show dependent code
Package BodyPO_POXRQRSR_XMLP_PKG - show dependent code
Package BodyPO_POXRQSIN_XMLP_PKG - show dependent code
Package BodyPO_POXRQUNI_XMLP_PKG - show dependent code
Package BodyPO_POXRRVDR_XMLP_PKG - show dependent code
Package BodyPO_POXRVODS_XMLP_PKG - show dependent code
Package BodyPO_POXRVOVS_XMLP_PKG - show dependent code
Package BodyPO_POXRVRSR_XMLP_PKG - show dependent code
Package BodyPO_POXRVRTN_XMLP_PKG - show dependent code
Package BodyPO_POXRVXRV_XMLP_PKG - show dependent code
Package BodyPO_POXSERPR_XMLP_PKG - show dependent code
Package BodyPO_POXSUCAT_XMLP_PKG - show dependent code
Package BodyPO_POXSUMIT_XMLP_PKG - show dependent code
Package BodyPO_RCVTXRTR_NEW_XMLP_PKG - show dependent code
Package BodyPO_REQAPPROVAL_INIT1 - show dependent code
Package BodyPO_VAL_LINES2 - show dependent code
ViewRCV_RECEIPTS_PRINT
ViewRCV_RECEIPTS_PRINT_RMA