eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_CORE_SV SQL Statements

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

Line: 213


  g_TimeStack.DELETE;

Line: 214


  g_DebugLevels.DELETE;

Line: 419


    g_TimeStack.DELETE;

Line: 450


      g_TimeStack.DELETE;

Line: 1005


      g_CallStack.DELETE(g_CallStack.COUNT-1);

Line: 1037


    g_CallStack.DELETE(g_CallStack.COUNT-1);

Line: 1109


     SELECT meaning
     FROM   fnd_lookups
     WHERE  lookup_type = x_lookup_type  AND
            lookup_code = x_lookup_code;

Line: 1149


  SELECT DECODE(INSTR(x_match_key,'A'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'B'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'C'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'E'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'F'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'G'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'H'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'I'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'J'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'K'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'L'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'M'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'N'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'O'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'P'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'Q'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'R'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'S'),0,'N','Y'),
         -- we return Yes in industry attribute15 for bug
         'Y', --DECODE(INSTR(x_match_key,'T'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'U'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'V'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'W'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'X'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'Y'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'Z'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'1'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'2'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'3'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'4'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'5'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'6'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'7'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'8'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'9'),0,'N','Y'),
         DECODE(INSTR(x_match_key,'$'),0,'N','Y')
  INTO
         x_match_rec.cust_production_line,
         x_match_rec.customer_dock_code,
         x_match_rec.request_date,
         x_match_rec.cust_po_number,
         x_match_rec.customer_item_revision,
         x_match_rec.customer_job,
         x_match_rec.cust_model_serial_number,
         x_match_rec.industry_attribute1,
         x_match_rec.industry_attribute2,
         x_match_rec.industry_attribute4,
         x_match_rec.industry_attribute5,
         x_match_rec.industry_attribute6,
         x_match_rec.industry_attribute9,
         x_match_rec.industry_attribute10,
         x_match_rec.industry_attribute11,
         x_match_rec.industry_attribute12,
         x_match_rec.industry_attribute13,
         x_match_rec.industry_attribute14,
         x_match_rec.industry_attribute15,
         x_match_rec.attribute1,
         x_match_rec.attribute2,
         x_match_rec.attribute3,
         x_match_rec.attribute4,
         x_match_rec.attribute5,
         x_match_rec.attribute6,
         x_match_rec.attribute7,
         x_match_rec.attribute8,
         x_match_rec.attribute9,
         x_match_rec.attribute10,
         x_match_rec.attribute11,
         x_match_rec.attribute12,
         x_match_rec.attribute13,
         x_match_rec.attribute14,
         x_match_rec.attribute15,
         x_match_rec.cust_production_seq_num
  FROM dual;

Line: 1302


     SELECT   PARTY.PARTY_NAME customer_name
     FROM     HZ_PARTIES PARTY,
              HZ_CUST_ACCOUNTS CUST_ACCT
     WHERE    CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
     AND      cust_acct.cust_account_id = x_customer_id;

Line: 1342


     SELECT customer_item_number
     FROM   mtl_customer_items
     WHERE  customer_item_id = x_item_id;

Line: 1379


     	SELECT MP.ORGANIZATION_CODE
	FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP
	WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
	AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HOI1.ORG_INFORMATION1 = 'INV'
	AND HOI1.ORG_INFORMATION2 = 'Y'
	AND ( HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
	AND HOU.ORGANIZATION_ID = x_ship_from_id;

Line: 1421


     select acct_site.ece_tp_location_code ece_tp_location_code
     from   hz_cust_acct_sites acct_site
     where  acct_site.cust_acct_site_id  = x_ship_to_id;

Line: 1466


    UPDATE rlm_interface_headers
    SET process_status            = rlm_core_sv.k_PS_ERROR,
        last_update_login         = fnd_global.login_id ,
        request_id                = fnd_global.conc_REQUEST_ID ,
        program_application_id    = fnd_global.PROG_APPL_ID ,
        program_id                = fnd_global.conc_program_id,
        program_update_date       = sysdate
    WHERE header_id = x_header_id;

Line: 1475


    dlog('No of interface headers Updated ', SQL%ROWCOUNT);

Line: 1477


    UPDATE rlm_interface_lines
    SET process_status            = rlm_core_sv.k_PS_ERROR,
        last_update_login         = fnd_global.login_id ,
        request_id                = fnd_global.conc_REQUEST_ID ,
        program_application_id    = fnd_global.PROG_APPL_ID ,
        program_id                = fnd_global.conc_program_id,
        program_update_date       = sysdate
    WHERE header_id = x_header_id;

Line: 1486


    dlog('No of interface Lines Updated ', SQL%ROWCOUNT);

Line: 1490


      UPDATE rlm_schedule_headers
      SET process_status            = rlm_core_sv.k_PS_ERROR,
        last_update_login         = fnd_global.login_id ,
        request_id                = fnd_global.conc_REQUEST_ID ,
        program_application_id    = fnd_global.PROG_APPL_ID ,
        program_id                = fnd_global.conc_program_id,
        program_update_date       = sysdate
      WHERE header_id = x_sch_header_id;

Line: 1499


      dlog('No of schedule headers Updated ', SQL%ROWCOUNT);

Line: 1501


      UPDATE rlm_schedule_lines
      SET process_status            = rlm_core_sv.k_PS_ERROR,
        last_update_login         = fnd_global.login_id ,
        request_id                = fnd_global.conc_REQUEST_ID ,
        program_application_id    = fnd_global.PROG_APPL_ID ,
        program_id                = fnd_global.conc_program_id,
        program_update_date       = sysdate
      WHERE header_id = x_sch_header_id;

Line: 1510


      dlog('No of schedule Lines Updated ', SQL%ROWCOUNT);

Line: 1541


     SELECT schedule_reference_num
     FROM   rlm_interface_headers
     WHERE  header_id  = x_header_id;

Line: 34046


     SELECT line_number
     FROM   rlm_schedule_lines_all
     WHERE  line_id  = x_line_id;

Line: 34082


     SELECT to_char(line_number)||'.'||
            to_char(shipment_number) ||
	    decode(option_number,NULL,NULL,'.'||to_char(option_number))
     FROM   oe_order_lines_all
     WHERE  line_id  = x_line_id;

Line: 34120


     SELECT order_number
     FROM   oe_order_headers_all
     WHERE  header_id  = x_header_id;

Line: 34156


     SELECT meaning
     FROM   fnd_lookups
     WHERE  lookup_code = x_status
     AND    lookup_type = 'RLM_PROCESS_STATUS';