Total Pageviews

September 8, 2015

9/08/2015 10:36:00 AM
Oracle APPS trainingScenario:

  Enabling the parameter based on the value of the first parameter

   
Oracle  APPS Reports

MRP/MDS Options --- 1, 2, 3

MDS    --- 1
MRP    --- 2
MPS    --- 3


---- MRP/MDS Options ------   Parameter    Value Set -- LOGI_MRP_MDS_OPTIONS

MDS DUMMY          --LOGI_MDS_NAME_DUMMY
select 1 from dual where :$FLEX$.LOGI_MRP_MDS_OPTIONS = 1

MRP DUMMY    --LOGI_MRP_NAME_DUMMY
select 1 from dual where :$FLEX$.LOGI_MRP_MDS_OPTIONS = 2

MPS DUMMY   -- LOGI_MPS_NAME_DUMMY
Select 1 from dual where :$FLEX$.LOGI_MRP_MDS_OPTIONS = 3




 
Related Posts Plugin for WordPress, Blogger...