VIEW: APPS.CN_OBJ_PROCEDURES_V

Source

View Text - Preformatted

SELECT o.rowid, o.object_id, o.last_update_date, o.last_updated_by, o.creation_date, o.created_by, o.last_update_login, o.name, o.description, o.dependency_map_complete, o.next_synchronization_date, o.synchronization_frequency, o.object_status, o.repository_id, o.parameter_list, o.return_type, o.procedure_type, o.package_id, o.child_flag, o.public_flag, o.statement_text, o.seed_object_id, o.object_type FROM CN_OBJECTS O WHERE o.object_type = 'PRC'

View Text - HTML Formatted

SELECT O.ROWID
, O.OBJECT_ID
, O.LAST_UPDATE_DATE
, O.LAST_UPDATED_BY
, O.CREATION_DATE
, O.CREATED_BY
, O.LAST_UPDATE_LOGIN
, O.NAME
, O.DESCRIPTION
, O.DEPENDENCY_MAP_COMPLETE
, O.NEXT_SYNCHRONIZATION_DATE
, O.SYNCHRONIZATION_FREQUENCY
, O.OBJECT_STATUS
, O.REPOSITORY_ID
, O.PARAMETER_LIST
, O.RETURN_TYPE
, O.PROCEDURE_TYPE
, O.PACKAGE_ID
, O.CHILD_FLAG
, O.PUBLIC_FLAG
, O.STATEMENT_TEXT
, O.SEED_OBJECT_ID
, O.OBJECT_TYPE
FROM CN_OBJECTS O
WHERE O.OBJECT_TYPE = 'PRC'