APPS.INVPVDR4 SQL Statements

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

Line: 34

      SELECT ROWID, intf.*
      FROM  mtl_system_items_interface intf
      WHERE((intf.organization_id = org_id) OR (all_Org = 1) )
         AND intf.set_process_id = xset_id
         AND intf.process_flag in (31, 32, 33, 43);

Line: 41

      SELECT 'Y'
      FROM   USER_TAB_COLUMNS
      WHERE  TABLE_NAME    = 'OKS_COVERAGE_TEMPLTS_V'
      AND    COLUMN_NAME   = 'ITEM_TYPE';

Line: 49

      SELECT 'x'
      FROM  MFG_LOOKUPS
      WHERE  LOOKUP_TYPE    = cp_lookup_type
      AND    LOOKUP_CODE    = cp_lookup_code
      AND    SYSDATE  BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
      AND    ENABLED_FLAG   = 'Y';

Line: 59

      SELECT 'x'
      FROM  FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = cp_lookup_type
      AND   LOOKUP_CODE = cp_lookup_code
      AND   SYSDATE BETWEEN  NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
      AND   ENABLED_FLAG = 'Y';

Line: 436

            SELECT 'valid_tax_code' into pur_dummy
            FROM dual
            WHERE EXISTS( SELECT NULL
                          FROM  zx_input_classifications_v
                          WHERE tax_type not in ('AWT','OFFSET')
                          AND   enabled_flag = 'Y'
                          AND   sysdate between start_date_active and  nvl(end_date_active,sysdate)
                          AND   lookup_code = cr.purchasing_tax_code
                          AND   org_id IN (-99,(SELECT org_information3 FROM  hr_organization_information
                                                WHERE ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
                                                       AND ORGANIZATION_ID=cr.organization_id)))
            AND ROWNUM = 1;

Line: 638

                      'SELECT ''x'' INTO :temp                        '||
                      'FROM  OKS_COVERAGE_TEMPLTS_V                   '||
                      'WHERE  ITEM_TYPE = :cr.CONTRACT_ITEM_TYPE_CODE '||
                      'AND  ID          = :cr.COVERAGE_SCHEDULE_ID    '||
                      'AND  SYSDATE BETWEEN  NVL(start_date, SYSDATE-1) AND NVL(end_date, SYSDATE+1); '||

Line: 646

                  SELECT 'x' INTO temp
                  FROM  OKS_COVERAGE_TEMPLTS_V
                  WHERE ID          = cr.COVERAGE_SCHEDULE_ID
                  AND  SYSDATE BETWEEN  NVL(start_date, SYSDATE-1) AND NVL(end_date, SYSDATE+1);

Line: 1149

            SELECT 'x' INTO temp
            FROM  MTL_PARAMETERS
            WHERE  ORGANIZATION_ID = cr.organization_id
            AND  (NVL(EAM_ENABLED_FLAG, 'N') = 'Y' or cr.organization_id = master_organization_id);

Line: 1567

            SELECT 'x' INTO temp
            FROM  OE_LOOKUPS
            WHERE LOOKUP_TYPE = 'SOURCE_TYPE'
            AND   LOOKUP_CODE = cr.DEFAULT_SO_SOURCE_TYPE
            AND   SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE)
            AND   ENABLED_FLAG = 'Y';

Line: 1685

      /* R12 C Weight UOM Code can now be updated for Pending items. Moving the below set of validations to INVPVHDR
      l_col_name := NULL;

Line: 1752

                /* NP26DEC94 : New code to update process_flag.
                ** This code necessiated due to the breaking up INVPVHDR into
                ** 6 smaller packages to overcome PL/SQL limitations with code size.
                ** Let's update the process flag for the record
                ** Give it value 42 if all okay and 32 if some validation failed in this procedure
                ** Need to do this ONLY if all previous validation okay.
                ** The process flag values that are possible at this time are
                ** 31, :set by INVPVHDR
                ** 32, :set by INVPVDR2
                ** 33, 43 :set by INVPVDR3
                */

      stmt := 911;

Line: 1767

      SELECT process_flag into temp_proc_flag
      FROM MTL_SYSTEM_ITEMS_INTERFACE
      WHERE inventory_item_id = l_item_id
      AND   set_process_id + 0 = xset_id
      AND   process_flag in (31,32,33,43)
      AND   organization_id = cr.organization_id
      AND   rownum < 2; */

Line: 1787

         UPDATE MTL_SYSTEM_ITEMS_INTERFACE
         SET process_flag = DECODE(status,0,44,34),
             PRIMARY_UOM_CODE = cr.primary_uom_code,
             primary_unit_of_measure = cr.primary_unit_of_measure
         WHERE inventory_item_id = l_item_id
         AND   set_process_id + 0 = xset_id
         AND   process_flag = 43
         AND   organization_id = cr.organization_id;