APPS.CSTPSMCM SQL Statements

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

Line: 26

      SELECT DISTINCT organization_id
      FROM   WSM_SPLIT_MERGE_TRANSACTIONS
      WHERE  STATUS = WIP_CONSTANTS.COMPLETED
      AND    COSTED IN (WIP_CONSTANTS.PENDING,WIP_CONSTANTS.ERROR);

Line: 46

   SELECT fcr.request_id
   INTO   l_dummy
   FROM   fnd_concurrent_requests fcr
   WHERE  program_application_id = 702
   AND    concurrent_program_id = l_program_id
   AND     phase_code IN ('I','P','R')
   AND    fcr.request_id <> l_request_id
   AND    ROWNUM=1;

Line: 72

      SELECT wsm_split_merge_transactions_s.nextval
      INTO   l_group_id
      FROM   dual;

Line: 77

      UPDATE wsm_split_merge_transactions
      SET    group_id = l_group_id,
             costed   = WIP_CONSTANTS.PENDING
      WHERE  organization_id = l_org_id
      AND    status = WIP_CONSTANTS.COMPLETED
      AND    COSTED IN (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.ERROR);