Oracle Apps Script for Download the Details of Custom Objects from Oracle Database and Application Server Like fmb, rdf, Xml, rtf, OAF, ldt script for cp etc
-----------------------------------------------------
-- FOR ALL OBJECT_NAME - (CUSTOM DEVELOPMENT OBJECTS)
-----------------------------------------------------
SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS
FROM ALL_OBJECTS AB
WHERE 1=1
AND UPPER(AB.OBJECT_NAME) LIKE UPPER('XXRMC%')
-- AND TRUNC(LAST_DDL_TIME) > '05-May-21'
-- AND TRUNC(CREATED) >= '05-May-21'
--AND OWNER <> 'PWCSS'
AND OBJECT_TYPE <> 'SYNONYM'
UNION ALL
SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS
FROM ALL_OBJECTS AB
WHERE 1=1
AND UPPER(AB.OBJECT_NAME) LIKE UPPER('XXCUS%')
-- AND TRUNC(LAST_DDL_TIME) > '05-May-21'
--AND OWNER <> 'PWCSS'
AND OBJECT_TYPE <> 'SYNONYM'
UNION ALL
SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS
FROM ALL_OBJECTS AB
WHERE 1=1
AND UPPER(AB.OBJECT_NAME) LIKE UPPER('XXTEX%')
-- AND TRUNC(LAST_DDL_TIME) > '05-May-21'
--AND OWNER <> 'PWCSS'
AND OBJECT_TYPE <> 'SYNONYM'
UNION ALL
SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS
FROM ALL_OBJECTS AB
WHERE 1=1
AND UPPER(AB.OBJECT_NAME) LIKE UPPER('RMC%')
-- AND TRUNC(LAST_DDL_TIME) > '05-May-21'
--AND OWNER <> 'PWCSS'
AND OBJECT_TYPE <> 'SYNONYM'
UNION ALL
SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS
FROM ALL_OBJECTS AB
WHERE 1=1
AND UPPER(AB.OBJECT_NAME) LIKE UPPER('XX_%')
-- AND TRUNC(LAST_DDL_TIME) > '05-May-21'
-- AND TRUNC(CREATED) >= '05-May-21'
--AND OWNER <> 'PWCSS'
AND OBJECT_TYPE <> 'SYNONYM'
ORDER BY OBJECT_TYPE,OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM SEQUENCE)
-----------------------------------------------------
SELECT AB.*
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'SEQUENCE'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND AB.OWNER ='APPS'
--AND STATUS = 'INVALID'
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM TABLE)
-----------------------------------------------------
SELECT AB.*
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'TABLE'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND AB.OWNER ='APPS'
--AND STATUS = 'INVALID'
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM INDEX)
-----------------------------------------------------
SELECT AB.*
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'INDEX'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND STATUS = 'VALID'
--AND STATUS = 'INVALID'
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM VIEW)
-----------------------------------------------------
SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'VIEW'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND AB.OWNER ='PWCSS'
--AND STATUS = 'INVALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM TRIGGER)
-----------------------------------------------------
SELECT AB.*
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'TRIGGER'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND AB.OWNER ='PWCSS'
--AND STATUS = 'VALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM FUNCTION)
-----------------------------------------------------
SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'FUNCTION'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND AB.OWNER ='PWCSS'
--AND STATUS = 'VALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM PROCEDURE)
-----------------------------------------------------
SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'PROCEDURE'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND AB.OWNER ='APPS'
--AND STATUS = 'VALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM PACKAGE)
-----------------------------------------------------
SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'PACKAGE'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND AB.OWNER ='PWCSS'
--AND STATUS = 'INVALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM PACKAGE BODY)
-----------------------------------------------------
SELECT AB.OWNER || '.' || AB.OBJECT_NAME,AB.OBJECT_TYPE
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'PACKAGE BODY'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND AB.OWNER ='PWCSS'
--AND STATUS = 'INVALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM NOT EQUAL TO SYNONYM)
-----------------------------------------------------
SELECT AB.*
FROM ALL_OBJECTS AB
WHERE 1=1
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
AND OBJECT_TYPE <>'SYNONYM'
--AND AB.OWNER ='APPS'
--AND STATUS = 'VALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM SYNONYM)
-----------------------------------------------------
SELECT AB.*
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'SYNONYM'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND STATUS = 'INVALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT_TYPE - (CUSTOM TYPE)
-----------------------------------------------------
SELECT AB.*
FROM ALL_OBJECTS AB
WHERE AB.OBJECT_TYPE = 'TYPE'
AND(AB.OBJECT_NAME LIKE 'XXRMC%' OR AB.OBJECT_NAME LIKE 'XXCUS%'
OR AB.OBJECT_NAME LIKE 'XXTEX%' OR AB.OBJECT_NAME LIKE 'RMC%'
OR AB.OBJECT_NAME LIKE 'XX%')
--AND STATUS = 'INVALID'
--ORDER BY AB.OBJECT_NAME
-----------------------------------------------------
-- FOR OBJECT LDT SCRIPT - (How to make ldt?)
-----------------------------------------------------
-----------------------------------------------------
-- FOR CONCURRENT PROGRAM (CP) LDT SCRIPT - DOWNLOAD
-----------------------------------------------------
FNDLOAD apps/Fire#321 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct PWCSS_BBU_TRANSFER_CP.ldt PROGRAM APPLICATION_SHORT_NAME='PWCSS' CONCURRENT_PROGRAM_NAME='PWCSS_BBU_TRANSFER'
-----------------------------------------------------
-- FOR DATA DEFINITION (DD) LDT SCRIPT - DOWNLOAD
-----------------------------------------------------
FNDLOAD apps/Fire#321 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct PWCSS004_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='PWCSS' DATA_SOURCE_CODE='PWCSS004' TMPL_APP_SHORT_NAME='PWCSS' TEMPLATE_CODE='PWCSS004'
-----------------------------------------------------
-- FOR FUNCTION (FUNC) LDT SCRIPT - DOWNLOAD
-----------------------------------------------------
FNDLOAD apps/ebsuat4#app 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct PWCSS001_FUNC.ldt FUNCTION FUNCTION_NAME="PWCSS001"
-----------------------------------------------------
-- FOR LOOKUP (LKUP) LDT SCRIPT - DOWNLOAD
-----------------------------------------------------
FNDLOAD apps/ebsuat4#app 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct PWCSS_WIP_SUPPLY_SALES_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='PWCSS' LOOKUP_TYPE='PWCSS_WIP_SUPPLY_SALES'
-----------------------------------------------------
-- FOR MENU (MENU) LDT SCRIPT - DOWNLOAD
-----------------------------------------------------
FNDLOAD apps/ebsuat4#app O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct PWCSS_SITE_SOLUTION_SU_MENU.ldt MENU MENU_NAME='PWCSS_SITE_SOLUTION_SU'
-----------------------------------------------------
-- FOR RESPONSIBILTY (RESP) LDT SCRIPT - DOWNLOAD
-----------------------------------------------------
FNDLOAD apps/ebsuat4#app 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct POLYCAB_SITE_SOLN_SU_RESP.ldt FND_RESPONSIBILITY RESP_KEY='POLYCAB_SITE_SOLN_SU'
-----------------------------------------------------
-- FOR RTF (RTF) LDT SCRIPT - DOWNLOAD
-----------------------------------------------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD Fire#321 -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.7.4.210)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ebs_EBSDEV)))' -LOB_TYPE TEMPLATE -LOB_CODE XXPLY_POCM -APPS_SHORT_NAME XXPLY -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME
-----------------------------------------------------
-- FOR VALUESET (VS) LDT SCRIPT - DOWNLOAD
-----------------------------------------------------
$FND_TOP/bin/FNDLOAD apps/ebsuat4#app 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXPOL_WO_NUM_SERVICE_VS_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME='XXPOL_WO_NUM_SERVICE_VS'
--=================================================================================--
--======================== SAMPLE HOW TO SAVE FILE ================================--
--=================================================================================--
--
-- PWCSS_SHIP_EXPORT_HDR_ID_S (Sequence)
--
CREATE SEQUENCE PWCSS.PWCSS_SHIP_EXPORT_HDR_ID_S
START WITH 1
MAXVALUE 999999999999999999999999999
MINVALUE 0
NOCYCLE
NOCACHE
NOORDER
/
--
-- PWCSS_SHIP_EXPORT_HDR_ID_S (Synonym)
--
CREATE OR REPLACE SYNONYM APPS.PWCSS_SHIP_EXPORT_HDR_ID_S FOR PWCSS.PWCSS_SHIP_EXPORT_HDR_ID_S
/
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF CONCURRENT PROGRAM ===================--
--=================================================================================--
SELECT A.CONCURRENT_PROGRAM_NAME,B.USER_CONCURRENT_PROGRAM_NAME
FROM fnd_concurrent_programs A,
fnd_concurrent_programs_tl B
WHERE A.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID
AND(CONCURRENT_PROGRAM_NAME LIKE 'XXRMC%' OR CONCURRENT_PROGRAM_NAME LIKE 'XXCUS%'
OR CONCURRENT_PROGRAM_NAME LIKE 'XXTEX%' OR CONCURRENT_PROGRAM_NAME LIKE 'RMC%');
------------------
SELECT
fcpt.user_concurrent_program_name,
fcpt.description,
fcp.concurrent_program_name,
fe.executable_name,
(
SELECT
meaning
FROM
fnd_lookup_values
WHERE
1 = 1
AND lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND lookup_code = fe.execution_method_code
) execution_method,
fe.execution_file_name,
xddt.data_source_code,
xddt.data_source_name,
(
SELECT
file_name
FROM
xdo_lobs
WHERE
lob_code = xddt.data_source_code
AND lob_type = 'DATA_TEMPLATE'
AND xdo_file_type = 'XML-DATA-TEMPLATE'
AND ROWNUM = 1
) data_template,
xtb.template_code,
xtt.template_name,
xtb.template_type_code,
xtb.default_output_type,
xl.file_name rtf_template
FROM
fnd_executables fe,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
xdo_ds_definitions_tl xddt,
xdo_templates_b xtb,
xdo_templates_tl xtt,
xdo_lobs xl
WHERE
1 = 1
AND xl.lob_code (+) = xtb.template_code
AND xl.lob_type (+) IN ( 'TEMPLATE_SOURCE', 'TEMPLATE' )
AND xl.xdo_file_type (+) IN ( 'RTF', 'XLS' )
AND xtt.template_code (+) = xtb.template_code
AND xtb.data_source_code (+) = xddt.data_source_code
AND xddt.data_source_code (+) = fcp.concurrent_program_name
AND fe.executable_id = fcp.executable_id
AND fcp.concurrent_program_id = fcpt.concurrent_program_id
AND(fe.executable_name LIKE 'XXRMC%' OR fe.executable_name LIKE 'XXCUS%'
OR fe.executable_name LIKE 'XXTEX%' OR fe.executable_name LIKE 'RMC%');
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF MENU =================================--
--=================================================================================--
SELECT *
FROM FND_MENUS
WHERE (MENU_NAME LIKE 'XXRMC%' OR MENU_NAME LIKE 'XXCUS%'
OR MENU_NAME LIKE 'XXTEX%' OR MENU_NAME LIKE 'RMC%' OR MENU_NAME LIKE 'XX%')
ORDER BY MENU_NAME;
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF RESPONSIBILITY =======================--
--=================================================================================--
SELECT *
FROM FND_RESPONSIBILITY_VL
WHERE(RESPONSIBILITY_KEY LIKE 'XXRMC%' OR RESPONSIBILITY_KEY LIKE 'XXCUS%'
OR RESPONSIBILITY_KEY LIKE 'TEX%' OR RESPONSIBILITY_KEY LIKE 'RMC%'
OR RESPONSIBILITY_KEY LIKE 'XX%');
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF FND_LOOKUP_TYPES======================--
--=================================================================================--
SELECT *
FROM FND_LOOKUP_TYPES
WHERE(LOOKUP_TYPE LIKE 'XXRMC%' OR LOOKUP_TYPE LIKE 'XXCUS%'
OR LOOKUP_TYPE LIKE 'XXTEX%' OR LOOKUP_TYPE LIKE 'TEX%'
OR LOOKUP_TYPE LIKE 'RMC%' OR LOOKUP_TYPE LIKE 'XX%');
-----------------
SELECT *
FROM FND_FLEX_VALUE_SETS
WHERE (FLEX_VALUE_SET_NAME LIKE 'XXRMC%' OR FLEX_VALUE_SET_NAME LIKE 'XXCUS%'
OR FLEX_VALUE_SET_NAME LIKE 'XXTEX%' OR FLEX_VALUE_SET_NAME LIKE 'RMC%'
OR FLEX_VALUE_SET_NAME LIKE 'XX%')
-----------------
SELECT A2.LOOKUP_TYPE,
A2.MEANING "LOOKUP TYPE MEANING",
A2.DESCRIPTION "LOOKUP TYPE DESCRIPTION",
A1.LOOKUP_CODE,
A1.MEANING "LOOKUP VALUE MEANING",
A1.DESCRIPTION "LOOKUP VALUE DESCRIPTION"
FROM APPS.FND_LOOKUP_VALUES A1,APPS.FND_LOOKUP_TYPES_VL A2
WHERE (A1.LOOKUP_TYPE LIKE 'XXRMC%' OR A1.LOOKUP_TYPE LIKE 'XXCUS%'
OR A1.LOOKUP_TYPE LIKE 'XXTEX%' OR A1.LOOKUP_TYPE LIKE 'TEX%'
OR A1.LOOKUP_TYPE LIKE 'RMC%' OR A1.LOOKUP_TYPE LIKE 'XX%')
AND A1.LOOKUP_TYPE=A2.LOOKUP_TYPE
AND A1.LOOKUP_TYPE <> 'RMC BANK WITH NMAM CODE'
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF Data Source Name =====================--
--=================================================================================--
SELECT xddt.data_source_name "Data Source Name",
xddb.data_source_code "Code",
fat.application_name "Application Name"
FROM xdo_ds_definitions_b xddb,
xdo_ds_definitions_tl xddt,
fnd_application fa,
fnd_application_tl fat
WHERE ( XDDB.DATA_SOURCE_CODE LIKE 'XX%' OR XDDB.DATA_SOURCE_CODE LIKE 'XXRMC%' OR
XDDB.DATA_SOURCE_CODE LIKE 'XXCUS%' OR XDDB.DATA_SOURCE_CODE LIKE 'XXTEX%'
OR XDDB.DATA_SOURCE_CODE LIKE 'RMC%')
AND xddt.data_source_code = xddb.data_source_code
AND xddt.LANGUAGE = 'US'
AND fa.application_short_name = xddb.application_short_name
AND fat.application_id = fa.application_id
AND fat.LANGUAGE = 'US';
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF Data Source Name RTF =================--
--=================================================================================--
SELECT *
FROM XDO_TEMPLATES_TL
WHERE (TEMPLATE_CODE LIKE 'XX%' OR TEMPLATE_CODE LIKE 'XXRMC%'
OR TEMPLATE_CODE LIKE 'XXCUS%' OR TEMPLATE_CODE LIKE 'XXTEX%'
OR TEMPLATE_CODE LIKE 'RMC%');
SELECT * FROM XDO_TEMPLATES_B ;
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM FORM FUNCTION =================--
--=================================================================================--
SELECT *
FROM FND_FORM_FUNCTIONS_VL
WHERE (FUNCTION_NAME LIKE 'XXRMC%' OR FUNCTION_NAME LIKE 'XXCUS%'
OR FUNCTION_NAME LIKE 'XXTEX%' OR FUNCTION_NAME LIKE 'RMC%'
OR FUNCTION_NAME LIKE 'XX%')
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM Workflow (WF) =================--
--=================================================================================--
SELECT WF.MESSAGE_TYPE WF_CODE, WF.DISPLAY_NAME WF_NAME , WF.DESCRIPTION WF_DESCRIPTION, WF.MESSAGE_NAME
FROM WF_NOTIFICATIONS WF,
WF_NOTIFICATION_ATTRIBUTES WFA,
WF_ITEM_TYPES_TL WF
WHERE WF.NOTIFICATION_ID =WFA.NOTIFICATION_ID
AND (WFA.TEXT_VALUE LIKE '%XX%' OR WF.NAME LIKE 'XX%' OR WFA.NAME LIKE '%XX%' )
AND WF.MESSAGE_TYPE NOT IN ('WFERROR','UMXLHELP', 'POERROR')
AND WF.MESSAGE_TYPE = WF.NAME
GROUP BY WF.DISPLAY_NAME, WF.DESCRIPTION , WF.MESSAGE_TYPE , WF.MESSAGE_NAME
ORDER BY 1
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM FORM PERSONALIZATION===========--
--=================================================================================--
SELECT A.SEQUENCE,
A.FUNCTION_NAME,
A.FORM_NAME,
A.ENABLED,
C.USER_FORM_NAME,
D.APPLICATION_NAME,
A.DESCRIPTION,
DECODE (A.RULE_TYPE,
'F', 'Form',
'A', 'Function',
'Other'
) "Level",
a.trigger_event,
a.trigger_object,
a.condition,
DECODE (a.fire_in_enter_query,
'Y', 'Both',
'N', 'Not in Enter-Query Mode',
'O', 'Only in Enter-Query Mode',
'Other'
) "Processing Mode",
ca.SEQUENCE,
DECODE (ca.ACTION_TYPE,
'S', 'Menu',
'P', 'Property',
'B', 'Builtin',
'M', 'Message',
ca.ACTION_TYPE ) Type,
ca.ARGUMENT_TYPE,
ca.ENABLED, ca.OBJECT_TYPE, ca.FOLDER_PROMPT_BLOCK, ca.MESSAGE_TYPE, ca.MESSAGE_TEXT,
ca.SUMMARY, ca.BUILTIN_TYPE, ca.BUILTIN_ARGUMENTS ,
ca.RULE_ID, ca.PROPERTY_NAME,ca.PROPERTY_VALUE,ca.TARGET_OBJECT,
ca.MENU_ENTRY, ca.MENU_LABEL, ca.MENU_SEPERATOR, ca.MENU_ENABLED_IN,
ca.MENU_ACTION, ca.MENU_ARGUMENT_LONG
FROM fnd_form_custom_rules a,
fnd_form b,
fnd_form_tl c,
fnd_application_tl d,
fnd_form_custom_actions ca
WHERE a.form_name = b.form_name
AND b.form_id = c.form_id
AND b.application_id = d.application_id
--AND a.description like 'SINP - Terms and Conditions menu'
AND a.enabled = 'Y'
AND a.ID = ca.rule_id
ORDER BY a.function_name, a.SEQUENCE, ca.SEQUENCE
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM OAF_FMB FORM ==================--
--=================================================================================--
SELECT F.FORM_NAME,
B.FUNCTION_NAME,
B.APPLICATION_ID,
DECODE (B.TYPE, 'FORM', 'FMB FORM', 'JSP', 'OAF PAGE',B.TYPE ) FORM_TYPE ,
T.USER_FUNCTION_NAME,
T.DESCRIPTION,
B.WEB_HTML_CALL
FROM FND_FORM_FUNCTIONS_TL T,
FND_FORM_FUNCTIONS B,
FND_FORM F
WHERE B.FUNCTION_ID = T.FUNCTION_ID
AND B.FORM_ID = F.FORM_ID (+)
AND (B.FUNCTION_NAME LIKE 'XX%' OR B.FUNCTION_NAME LIKE '%XXCUS%')
ORDER BY 3;
--=================================================================================--
--========== SCRIPT FOR FETCH THE DETAILS OF CUSTOM OAF PAGE QUERY ================--
--=================================================================================--
SELECT JDR_MDS_INTERNAL.GETDOCUMENTNAME(JP.PATH_DOCID) DOCUMENT_PATH,
JA.ATT_VALUE PERSONALIZATION_PATH,
JP.PATH_NAME DOCUMENT_NAME,
ATT_NAME CUSTOMIZE_CLASS_TYPE,
COMP_ID COLUMNCONTROLLER_NAME,
JC.COMP_ELEMENT COLUMN_TYPE
FROM JDR_PATHS JP,
JDR_ATTRIBUTES JA,
JDR_COMPONENTS JC
WHERE JP.PATH_DOCID = JA.ATT_COMP_DOCID
AND JP.PATH_DOCID = JC.COMP_DOCID
AND ATT_NAME IN ( 'customizes', 'controllerClass' )
AND ( JC.COMP_ID LIKE 'XX%' OR JC.COMP_ID LIKE '%XXCUS%' )
No comments:
Post a Comment