APPS.MSC_BI2EBS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

SELECT
HEADER_ID,
fnd_run_function.get_run_function_url(
     CAST(fnd_function.get_function_id('ISC_ORDINF_DETAILS_PMV') AS NUMBER),
     CAST( VALUEOF(NQ_SESSION.OLTP_EBS_RESP_APPL_ID) AS NUMBER),
     CAST( VALUEOF(NQ_SESSION.OLTP_EBS_RESP_ID) AS NUMBER),
     CAST( VALUEOF(NQ_SESSION.OLTP_EBS_SEC_GROUP_ID) AS NUMBER),
'HeaderId='||HEADER_ID||'&pFunctionName=ISC_ORDINF_DETAILS_PMV&pMode=NO&pageFunctionName=ISC_ORDINF_DETAILS_PMV',
     NULL) as ORDER_HEADER_ACTION_LINK_URL


*/



value_delimeter                                    constant varchar2(3):='%3B'; ---;

Line: 92

  select plan_id from msc_plan_runs
  where plan_run_name = p_plan_run_name;

Line: 96

  SELECT MTP.SR_INSTANCE_ID, MTP.SR_TP_ID
  from msc_trading_partners mtp
  where mtp.organization_code = p_org_name
  and mtp.partner_type=3;

Line: 102

   select sr_category_id from msc_phub_categories_mv
   where CATEGORY_NAME = p_category_name
   and category_set_id = fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

Line: 107

   select unique inventory_item_id from msc_system_items
   where item_name=p_item_name
   and plan_id = p_plan_id;

Line: 112

  SELECT unique MDR.RESOURCE_ID
  FROM MSC_DEPARTMENT_RESOURCES MDR, MFG_LOOKUPS ML1,MFG_LOOKUPS ML2
  where MDR.RESOURCE_CODE = p_res_name
  and   mdr.plan_id =p_plan_id
   and ML1.LOOKUP_CODE = nvl(MDR.BOTTLENECK_FLAG,2)
  AND ML1.LOOKUP_TYPE = 'SYS_YES_NO'
  AND ML2.LOOKUP_CODE = MDR.RESOURCE_TYPE
  AND ML2.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE';

Line: 122

    SELECT lookup_code exception_type_id FROM mfg_lookups
    WHERE lookup_type = 'MRP_EXCEPTION_CODE_TYPE'
    and lookup_code not in (101,102,103,104)
    and meaning =p_exp_name;

Line: 156

    select FND_GLOBAL.RESP_ID, FND_GLOBAL.RESP_APPL_ID,FND_GLOBAL.SECURITY_GROUP_ID
    into  l_resp_id,l_appl_id,l_sec_group_id
    from dual;

Line: 365

        select fnd_profile.value('MSD_DEM_SCHEMA') into l_schema from dual;

Line: 371

    l_sql_qid :='select query_id from '||l_schema||'.queries where query_name=:1';

Line: 372

    l_sql_lid :='select group_table_id,gtable,id_field,data_field from '||l_schema||'.group_tables where table_label=:1';

Line: 406

       l_sql_statement:='select ' || l_id_field || ' from '||l_schema||'.' || l_gtable ||
                      ' where ' || l_data_field  || '= :1' ;