APPS.MRP_RELEASE_EAM_WO SQL Statements

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

Line: 39

    lv_update_stmt VARCHAR2(2000) ;

Line: 55

    lv_cur_stmt :=  ' SELECT DISTINCT SOURCE_LINE_ID ,ORGANIZATION_ID '
                  ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||g_dblink
                  ||' WHERE group_id = '||g_group_id
                  ||' AND MAINTENANCE_OBJECT_SOURCE=1'
                  ||' AND LOAD_TYPE = 257 ';

Line: 107

        lv_sql_stmt := 'DELETE msc_wip_job_schedule_interface'||g_dblink
                      ||' where sr_instance_id ='||  P_SR_INSTANCE_ID
                      ||' and nvl(group_id,-1) = nvl('||g_group_id||',-1)'
                      ||' and maintenance_object_source =1 '
                      ||' and load_type =257';

Line: 146

    v_updated_by number;

Line: 316

           select ltrim(rtrim(value)) into g_output_dir
           from (select value from v$parameter2  where name='utl_file_dir'
                                               order by rownum desc)
           where rownum <2;

Line: 484

  L_JOB_STMT := 'SELECT '
||'   ''MSC'' SOURCE_CODE '
||'   ,WJSI.SOURCE_LINE_ID '
||'   ,WJSI.ORGANIZATION_ID '
||'   ,WJSI.STATUS_TYPE '
||'   ,WJSI.FIRST_UNIT_START_DATE  '
||'   ,WJSI.PRIMARY_ITEM_ID REBUILD_ITEM_ID '
--||'   ,WJSI.BOM_REVISION_DATE '
--||'   ,WJSI.ROUTING_REVISION_DATE '
||'   ,WJSI.CLASS_CODE '
||'   ,WJSI.JOB_NAME '
||'   ,WJSI.FIRM_PLANNED_FLAG '
||'   ,WJSI.ALTERNATE_ROUTING_DESIGNATOR '
||'   ,WJSI.ALTERNATE_BOM_DESIGNATOR '
||'   ,WJSI.NET_QUANTITY '
||'   ,WJSI.WIP_ENTITY_ID '
||'   ,WJSI.SCHEDULE_GROUP_ID '
||'   ,WJSI.PROJECT_ID '
||'   ,WJSI.TASK_ID '
||'   ,WJSI.END_ITEM_UNIT_NUMBER '
||'   ,WJSI.HEADER_ID '
||'   ,WJSI.LAST_UNIT_COMPLETION_DATE  '
||'   ,6 ACTIVITY_TYPE '
||'   ,WJSI.PRIMARY_ITEM_ID MAINTENANCE_OBJECT_ID '
||'   ,2 MAINETNANCE_OBJECT_TYPE '
||'   ,1 MAINTENANCE_OBJECT_SOURCE '
||'   ,null DATE_RELEASED '
||'   ,null OWNING_DEPARTMENT '
||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||g_dblink||' WJSI '
||' WHERE WJSI.ORGANIZATION_ID =  :V_ORGANIZATION_ID'
||' AND WJSI.GROUP_ID = :GROUP_ID'
||' AND WJSI.SOURCE_LINE_ID = :V_SOURCE_LINE_ID'
||' AND MAINTENANCE_OBJECT_SOURCE =1'
||' AND LOAD_TYPE =257 ';

Line: 520

           L_EAM_WO_TBL.delete(L_EAM_WO_TBL.FIRST,L_EAM_WO_TBL.last);