Oracle FNDLOAD Command and Script for Download and Upload .ldt files

Oracle FNDLOAD Scripts for Download and Upload .ldt files

 FNDLOAD Downloaded Upload LDT ldt  files and scripts



1. Lookups
-- -------------
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

2. Concurrent Program
-- -----------------------------
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

3. Profile
-- ---------
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

4. Request Set and Link
-- ------------------------------
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_CUSTOM_RS.ldt REQ_SET REQUEST_SET_NAME='REQUEST_SET_NAME'

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_CUSTOM_RS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

5. FND Message
-- ---------------------
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUST" MESSAGE_NAME="MESSAGE_NAME%"

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

6. D2K FORMS
-- ------------------
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt FORM FORM_NAME="FORM_NAME"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

7. Form Function
-- ---------------------
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt FUNCTION FUNCTION_NAME="FORM_FUNCTION_NAME"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

8. Alerts
-- ---------
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX - Alert Name"

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE

9. Value Set
-- --------------
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name"

$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

10. Data Definition and Associated Template
--- ----------------------------------------------------------
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='XX_SOURCE_CODE' TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='XX_SOURCE_CODE'

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt

11. DATA_TEMPLATE (Data Source .xml file)
--- ----------------------------------------------------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME

12. RTF TEMPLATE (Report Layout .rtf file)
--- -------------------------------------------------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NAME.rtf -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME



----------------------------------

1 - Printer Styles
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=”printer style name”
2 - Lookups
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”prod” LOOKUP_TYPE=”lookup name”

3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=”prod” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name” P_CONTEXT_CODE=”context name”

4 - Key Flexfield Structures
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=”prod” ID_FLEX_CODE=”key flex code” P_STRUCTURE_CODE=”structure name”

5 - Concurrent Programs
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=”prod” CONCURRENT_PROGRAM_NAME=”concurrent name”

6 - Value Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=”value set name”

7 - Value Sets with values
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name”

8 - Profile Options
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”prod”

9 - Requset Group
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_NAME=”prod”



10 - Request Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME=”prod” REQUEST_SET_NAME=”request set”

11 - Responsibilities
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY=”responsibility

12 - Menus
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=”menu_name”

13 – Forms/Functions
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt

14. User/Responsibilities

FNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER [<USER>]

Downloaded_Upload__ldt
FNDLOAD apps/clone O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct  XXPRDDSFTP.ldt PROGRAM APPLICATION_SHORT_NAME="XXPRD" CONCURRENT_PROGRAM_NAME="XXPRDDSFTP"

FNDLOAD apps/clone O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct  XXPRDSFTPH.ldt PROGRAM APPLICATION_SHORT_NAME="XXPRD" CONCURRENT_PROGRAM_NAME="XXPRDSFTPH"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXPRDDSFTP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXPRDSFTPH.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE



---fndload-for - commands

http://apps2fusion.com/apps/scripts/19-oracle-fndload-script-examples

---fndload-for-oracle-web-adi

http://apps2fusion.com/apps/apps/47-fndload-for-oracle-web-adi

R12 Upgrade Usefull Script

 R12 Upgrade Usefull Script

----------------------------------------------------------------

---  for forms                                    7-3-12       .

----------------------------------------------------------------

 

SELECT      application_name

           ,form_name

           ,fft.description

FROM        fnd_form             ff

           ,fnd_form_tl          fft

           ,fnd_application_tl   fat

WHERE       1=1

--

AND         ff.application_id  = fft.application_id

AND         ff.form_id         = fft.form_id

--

AND         ff.application_id  = fat.application_id

--

AND         form_name like 'XX%'

 

----------------------------------------------------------------

---  for OA Forms                               7-3-12         .

----------------------------------------------------------------

SELECT       ff.function_name

            ,user_function_name

            ,description

            ,decode(type,'JSP','OA Form',type) type

            ,web_host_name

            ,web_agent_name

            ,web_html_call

            ,context_dependence

FROM         fnd_form_functions     ff

            ,fnd_form_functions_tl  ft

WHERE       1=1

AND         ff.function_id  =  ft.function_id

AND         type ='JSP' AND function_name like 'XX%'

 

----------------------------------------------------------------

---  for XML Publisher Objects                          7-3-12 .

----------------------------------------------------------------

 

SELECT     executable_name

          --,meaning--fe.execution_method_code

          ,execution_file_name

          ,fcpt.user_concurrent_program_name  concurrent_program_name

          ,xddb.data_source_code short_code

          ,xddb.data_source_code data_definition_name

        --  ,template_id

          ,xtb.template_code

          ,xtt.template_name

FROM       xdo_ds_definitions_b        xddb

          ,xdo_templates_b             xtb

          ,xdo_templates_tl            xtt

          ,fnd_concurrent_programs     fcp

          ,fnd_concurrent_programs_tl  fcpt

          ,fnd_executables fe

         -- ,fnd_lookups

WHERE      1=1

--

AND        xddb.data_source_code        =  xtb.data_source_code

--

AND        xddb.data_source_code        =  concurrent_program_name

AND        xtb.application_id           =  fcp.application_id

--

AND        xtb.template_code            = xtt.template_code

--

AND        fcp.application_id           =  fcpt.application_id

AND        fcp.concurrent_program_id    =  fcpt.concurrent_program_id

--

AND        fcp.executable_id            =  fe.executable_id

--

--AND        lookup_code =  fe.execution_method_code 

--AND        xtb.application_id = 20003  --

AND        xddb.application_short_name like '%BOB%'   

AND         OUTPUT_FILE_TYPE = 'XML'   

--AND        xddb.data_source_code = 'XXBOB_TCAINTLRPT'

 

 

----------------------------------------------------------------

---  for Work Flow Objects                             7-3-12  .

----------------------------------------------------------------

 

SELECT  DISTINCT process_item_type workflow_name  

FROM    wf_process_activities

WHERE   process_item_type LIKE 'XX%'

 

----------------------------------------------------------------

---  for Alerts                                     7-3-12     .

----------------------------------------------------------------

SELECT      -- aa.application_id

             application_name

            ,alert_id

            ,alert_name

            ,aa.description

            ,table_name

            ,sql_statement_text

FROM         alr_alerts          aa

            ,fnd_application_tl  fat

WHERE        1=1

AND          aa.application_id  = fat.application_id

AND          alert_name like '%BOB%'  

 

 

----------------------------------------------------------------

---  for Work Flow Objects                             9-3-12  .

----------------------------------------------------------------

SELECT      concurrent_program_name        

           ,user_concurrent_program_name     

           ,application_short_name        

FROM        fnd_concurrent_programs    fcp

           ,fnd_concurrent_programs_tl fcpt

           ,fnd_application            fa

WHERE       1=1

AND         fcp.concurrent_program_id  = fcpt.concurrent_program_id

AND         fcp.application_id        = fa.application_id

AND         fa.application_id         = fcpt.application_id

AND         fcp.concurrent_program_name LIKE 'XX%'

 

select * from all_objects where object_name like 'XX%R12%'

 

------------------------------------------------------

--- QUERY TO GET THE PROFILE OPTIONS APPLICATION WISE.

------------------------------------------------------

SELECT       fpo.profile_option_name

           -- ,fpo.hierarchy_type

           -- ,fpo.start_date_Active

            ,fat.application_short_name

FROM         fnd_profile_options fpo

            ,fnd_application fat

WHERE        1=1

AND          fpo.application_id=fat.application_id

AND          profile_option_name like 'XX%'

GROUP BY     fpo.profile_option_name

           -- ,fpo.hierarchy_type 

            --,fpo.start_date_Active

            ,fat.application_short_name

ORDER BY 2 DESC

-----------------------------------

-- cursor for lookups styles      .

-----------------------------------

 

SELECT   fl.lookup_type

        ,flt.description

        ,flt.meaning  

        ,fa.application_short_name

FROM     fnd_lookup_types    fl

        ,fnd_lookup_types_tl flt

        ,fnd_application     fa  

WHERE    1=1

AND      fl.lookup_type = flt.lookup_type

AND      fl.application_id = fa.application_id

AND      fl.lookup_type LIKE 'XX%'

 

select * from fnd_application

 

SELECT  fat.application_short_name

       ,b.lookup_type

       ,t.description 

       ,t.meaning

FROM    fnd_lookup_types b

       ,fnd_lookup_types_tl t

       ,fnd_application fat

WHERE   1=1

AND     b.application_id=fat.application_id

AND     b.security_group_id=t.security_group_id

AND     b.view_application_id = t.view_application_id       

AND     t.description LIKE 'XX%'

GROUP BY fat.application_short_name

        ,b.lookup_type

        ,t.description

        ,t.meaning;

       

-------------------------------------------------

--- Descrptive flex fields                      .

-------------------------------------------------

         

select * from all_objects where object_name like 'FND%CONT%'         

         

select * from fnd_descriptive_flexs_tl where DESCRIPTIVE_FLEXFIELD_NAME like '%XX%'

 

select * from FND_DESCR_FLEX_CONTEXTS where DESCRIPTIVE_FLEXFIELD_NAME like '%XX%'

 

select * from FND_DESCR_FLEX_CONTEXTS_tl   --DESCRIPTIVE_FLEX_CONTEXT_CODE,DESCRIPTIVE_FLEX_CONTEXT_NAME

 

 

SELECT      fdf.descriptive_flexfield_name

           ,fdft.description

           ,fdfc.descriptive_flex_context_name

           ,fa.application_short_name

FROM        fnd_descriptive_flexs       fdf

           ,fnd_descriptive_flexs_tl    fdft

           ,fnd_descr_flex_contexts_tl  fdfc

           ,fnd_application             fa

WHERE       1=1

AND         fdf.application_id = fdft.application_id

AND         fdft.application_id = fdfc.application_id

--

AND         fdf.application_id = fa.application_id

AND         fa.application_id = fdft.application_id

AND         fa.application_id = fdfc.application_id

--      

AND         fdf.descriptive_flexfield_name  = fdft.descriptive_flexfield_name

AND         fdft.descriptive_flexfield_name = fdfc.descriptive_flexfield_name

AND         fdf.descriptive_flexfield_name LIKE  '%XX%'

 

 

---------------------------------------------------

----key flex fields                               .

---------------------------------------------------

SELECT      fi.id_flex_structure_code

           ,fi.id_flex_code

           ,fit.description

           ,fa.application_short_name

FROM        fnd_id_flex_structures      fi

           ,fnd_id_flex_structures_tl   fit

           ,fnd_application             fa

WHERE       1=1

AND         fa.application_id  =   fi.application_id

AND         fi.application_id  =   fa.application_id

AND         fi.id_flex_code    =   fit.id_flex_code

AND         fi.id_flex_num     =   fit.id_flex_num

AND         fi.id_flex_structure_code LIKE '%BOB%'

------------

 

-------------------------------------      

-- Reference Code                   .

-------------------------------------

SELECT      fi.id_flex_structure_code

           ,fit.id_flex_structure_name

           ,fit.description

           ,fs.application_column_name

           ,fs.segment_name

           ,fa.application_short_name

FROM        fnd_id_flex_structures      fi

           ,fnd_id_flex_structures_tl   fit

           ,fnd_id_flex_segments        fs

           ,fnd_application             fa

WHERE       1=1

AND         fi.application_id  =   fit.application_id

AND         fit.application_id =   fs.application_id

AND         fi.id_flex_code    =   fit.id_flex_code

AND         fit.id_flex_code   =   fs.id_flex_code

AND         fi.id_flex_num     =   fit.id_flex_num

AND         fit.id_flex_num    =   fs.id_flex_num

--

AND         fa.application_id  =   fi.application_id

AND         fa.application_id  =   fit.application_id

AND         fa.application_id  =   fs.application_id

AND         fi.id_flex_structure_code LIKE '%BOB%'

and         fi.id_flex_code = 'JOB'

        

select * from all_objects where object_name like 'FND%ID%'        

        

select * from FND_ID_FLEXS-- where ID_FLEX_CODE LIKE  '%XX%'

 

select * from FND_ID_FLEX_STRUCTURES  where ID_FLEX_STRUCTURE_CODE like '%BOB%'

 

select * from FND_ID_FLEX_STRUCTURES_tl  --where ID_FLEX_STRUCTURE_CODE like '%BOB%'

 

select distinct id_flex_code ,a.* from FND_ID_FLEX_SEGMENTS  a where id_flex_code = 'JOB'

 

---------------------------------------------------

---  Concurrent Program                           .

---------------------------------------------------

 

SELECT      concurrent_program_name        

           ,user_concurrent_program_name    

           ,application_short_name         

FROM        fnd_concurrent_programs    fcp

           ,fnd_concurrent_programs_tl fcpt

           ,fnd_application            fa

WHERE       1=1

AND         fcp.concurrent_program_id  = fcpt.concurrent_program_id

AND         fcp.application_id         = fa.application_id

AND         fa.application_id          = fcpt.application_id

AND         fcp.concurrent_program_name LIKE 'XX%';

 

 

---------------------------------------------------

--- value set.                                    .

---------------------------------------------------

SELECT  flex_value_set_name

       ,description

FROM    fnd_flex_value_sets

 

WHERE   flex_value_set_name LIKE 'XX%'

         

select * from all_objects where object_name like 'FND%VALUE%'  

         

select * from fnd_flex_value_sets where FLEX_VALUE_SET_NAME like 'XX%'

 

select * from FND_FLEX_VALUES_VL-- where FLEX_VALUE_SET_NAME like 'XX%'

 

 

 

---------------------------------------------------

--- value set values                              .

---------------------------------------------------

SELECT  flex_value_set_name

       ,ff.flex_value_set_id

       ,ff.description

       ,ffv.flex_value_id

       ,ffv.flex_value

       ,ffvt.description

       ,ffvt.flex_value_meaning

FROM    fnd_flex_value_sets ff

       ,fnd_flex_values     ffv

       ,fnd_flex_values_tl  ffvt

WHERE   1=1

AND     ff.flex_value_set_id  = ffv.flex_value_set_id

AND     ffv.flex_value_id     = ffvt.flex_value_id

AND     flex_value_set_name LIKE 'XX%'

 

select * from FND_FLEX_VALUES

 

select * from FND_FLEX_VALUES_tl

 

 

--------------------------------------

---Request Group                     .

--------------------------------------

 

SELECT      frg.request_group_name

           ,frg.description

           ,fa.application_short_name

FROM        fnd_request_groups frg

           ,fnd_application    fa

WHERE       frg.application_id=fa.application_id

AND         request_group_name LIKE'XX%'

 

select * from fnd_request_groups where request_group_name like'XX%'

 

select * from fnd_application

 

-----------------------------------------

---Responsibility                       .

-----------------------------------------

SELECT    responsibility_key  

         ,responsibility_name

         ,description

FROM      fnd_responsibility    fr   

         ,fnd_responsibility_tl frt

WHERE     1=1

AND       fr.application_id      =  frt.application_id

AND       fr.responsibility_id   =  frt.responsibility_id

AND       responsibility_name LIKE '%BOB%'

 

select * from fnd_responsibility where application_id='20003'

 

select * from fnd_responsibility_tl where RESPONSIBILITY_NAME like '%BOB%'

 

--------------------------------------------------

---Request set info                              .

--------------------------------------------------

SELECT    request_set_name

         ,frt.description 

         ,fa.application_short_name

FROM      fnd_request_sets     fr 

         ,fnd_request_sets_tl  frt

         ,fnd_application      fa

WHERE     1=1

AND       fr.application_id   = frt.application_id

AND       frt.application_id   = fa.application_id

AND       fr.request_set_id   = frt.request_set_id

AND       request_set_name like '%BOB%'

       

select * from fnd_request_sets where   REQUEST_SET_NAME like '%BOB%'

 

select * from fnd_application

 

select * from fnd_request_sets_tl

 

 

---------------------------------------------------

---PRINTER STYLE                                  .

---------------------------------------------------

SELECT  printer_style_name

       ,description

FROM    fnd_printer_styles a

 

 

 

SELECT distinct  fcpt.user_concurrent_program_name  "CONCURRENT PGM NAME"

                ,fcp.output_print_style             "PRINTER STYLE"                

FROM  fnd_concurrent_programs_tl fcpt

     ,fnd_concurrent_programs fcp

WHERE  fcpt.concurrent_program_id=fcp.concurrent_program_id

AND    fcpt.user_concurrent_program_name LIKE 'BOB%GL%' --'BOB%' 'XXBOB%'

GROUP BY  fcpt.user_concurrent_program_name

          ,fcp.output_print_style

ORDER BY 1

 

 

select * from all_objects where object_name like '%PRINT%'

 

select * from all_tables where table_name like '%PRINT%'

------------------------------------------

 

select * from dba_source where name like 'XX%' and  type = 'PACKAGE BODY' order by type

 

XXBOBHR_UTIL2_PKG

 

 

-------------------------------------------------------------

--- GL Related queries                                      .

-------------------------------------------------------------

select * from fnd_product_groups

 

select * from hrfv_business_groups

 

select * from gl_sets_of_books

 

select * from hr_legal_entities

 

select * from hr_operating_units

 

select * from org_organization_definitions

 

select * from gl_period_types where user_period_type like '%BOB%'

 

-----------------

---Calendar Types

-----------------

SELECT   PERIOD_TYPE

        ,NUMBER_PER_FISCAL_YEAR

        ,YEAR_TYPE_IN_NAME

        ,USER_PERIOD_TYPE

        ,DESCRIPTION

        ,PERIOD_TYPE_ID

FROM     gl_period_types

WHERE    1=1

AND      user_period_type LIKE '%BOB%' 

 

---------------------------

---Calendar Accounting infn

---------------------------

SELECT  PERIOD_SET_NAME     calendar_name

       ,DESCRIPTION

       ,PERIOD_SET_ID

FROM    GL_PERIOD_SETS

WHERE   1=1

AND     PERIOD_SET_NAME  LIKE '%BOB%'

 

-----------------------------------

-- cursor for from personalizations

-----------------------------------

SELECT ffcr.FUNCTION_NAME,

       ffcr.DESCRIPTION

FROM   FND_FORM_CUSTOM_RULES ffcr;