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.AHL_MC_RULE_ENGINE_PVT SQL Statements

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

Line: 45


SELECT DISTINCT rules.rule_id, uc.csi_item_instance_id
 FROM  AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc
WHERE rules.mc_header_id = uc.master_config_id
  AND uc.unit_config_header_id = p_uc_header_id
  AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
  AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
  AND rules.rule_type_code = p_rtype
  AND TRUNC(nvl(rules.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
  AND TRUNC(nvl(rules.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 56


SELECT uc.unit_config_header_id
 FROM  AHL_UNIT_CONFIG_HEADERS uc
START WITH  uc.unit_config_header_id = p_uc_header_id
  AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
  AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
CONNECT BY PRIOR uc.unit_config_header_id = uc.PARENT_UC_HEADER_ID
  AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
  AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 214


SELECT DISTINCT rules.rule_id, rules.rule_name, uc.csi_item_instance_id, uc.name
 FROM  AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc
WHERE rules.mc_header_id = uc.master_config_id
  AND uc.unit_config_header_id = p_uc_header_id
  AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
  AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
  AND rules.rule_type_code = p_rtype
  AND TRUNC(nvl(rules.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
  AND TRUNC(nvl(rules.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 225


SELECT uc.unit_config_header_id
 FROM  AHL_UNIT_CONFIG_HEADERS uc
START WITH  uc.unit_config_header_id = p_uc_header_id
  AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
  AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
CONNECT BY PRIOR uc.unit_config_header_id = uc.PARENT_UC_HEADER_ID
  AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
  AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 424


SELECT csi_ii.subject_id
  FROM csi_ii_relationships csi_ii
  START WITH csi_ii.object_id = p_csi_instance_id
    AND CSI_II.RELATIONSHIP_TYPE_CODE  = 'COMPONENT-OF'
    AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate-1)) <= TRUNC(sysdate)
    AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
  CONNECT BY PRIOR csi_ii.subject_id =  csi_ii.object_id
    AND CSI_II.RELATIONSHIP_TYPE_CODE  = 'COMPONENT-OF'
    AND trunc(nvl(CSI_II.ACTIVE_START_DATE, sysdate-1)) <= trunc(sysdate)
    AND trunc(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > trunc(sysdate);

Line: 437


SELECT distinct rul.rule_id, rul.rule_name, rul.mc_header_id
FROM AHL_MC_RULES_VL rul, AHL_MC_RULE_STATEMENTS rst,
     AHL_APPLICABLE_INSTANCES ap
 WHERE  rst.rule_id = rul.rule_id
   AND rul.rule_type_code = p_rule_type
   AND ((rst.subject_type = 'POSITION'
         AND  rst.subject_id =  ap.position_id )
       OR ((rst.object_type = 'ITEM_AS_POSITION' OR
            rst.object_type = 'CONFIG_AS_POSITION')
           AND rst.object_id = ap.position_id));

Line: 452


SELECT uch.csi_item_instance_id
 FROM ahl_unit_config_headers uch
 WHERE uch.master_config_id = p_mc_header_id
 AND uch.csi_item_instance_id = p_csi_instance_id
UNION ALL
SELECT csi_ii.object_id
  FROM csi_ii_relationships csi_ii
  WHERE csi_ii.object_id IN
  (SELECT csi_item_instance_id
     FROM ahl_unit_config_headers
    --mpothuku added '='
    WHERE trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)
    --mpothuku End
          AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
          AND master_config_id = p_mc_header_id)

  -- SATHAPLI::Bug# 6351371, 21-Aug-2007
  -- relationship start date check should include SYSDATE too
  START WITH csi_ii.subject_id = p_csi_instance_id
    AND CSI_II.RELATIONSHIP_TYPE_CODE  = 'COMPONENT-OF'
  --  AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
    AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
    AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
  CONNECT BY csi_ii.subject_id = PRIOR csi_ii.object_id
    AND CSI_II.RELATIONSHIP_TYPE_CODE  = 'COMPONENT-OF'
  --  AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
    AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
    AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 482


SELECT uch.name
 FROM ahl_unit_config_headers uch
 WHERE uch.csi_item_instance_id = p_csi_instance_id;

Line: 489


SELECT object_id
  FROM csi_ii_relationships
 WHERE subject_id = p_csi_instance_id
   AND TRUNC(nvl(ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
   AND TRUNC(nvl(ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 558


  EXECUTE IMMEDIATE 'DELETE FROM AHL_APPLICABLE_INSTANCES';

Line: 736


SELECT rule_statement_id
 FROM  AHL_MC_RULE_STATEMENTS
WHERE rule_id = p_rule_id
   AND top_rule_stmt_flag = 'T';

Line: 824


SELECT *
  FROM ahl_mc_rule_statements
 WHERE rule_statement_id = p_rulestmt_id;

Line: 829


SELECT inventory_item_id
  FROM CSI_ITEM_INSTANCES
 WHERE instance_id = p_csi_ii_id;

Line: 834


SELECT hd.mc_id, hd.version_number
FROM   AHL_MC_HEADERS_B hd, AHL_UNIT_CONFIG_HEADERS uc
WHERE  hd.mc_header_id = uc.master_config_id
AND   uc.csi_item_instance_id = p_csi_ii_id;

Line: 841


SELECT csi1.inventory_item_id
  FROM CSI_ITEM_INSTANCES csi1, CSI_ITEM_INSTANCES csi2
 WHERE csi1.instance_id = p_csi_ii_id1
   AND csi2.instance_id = p_csi_ii_id2
   AND csi1.inventory_item_id = csi2.inventory_item_id;

Line: 849


SELECT uc1.master_config_id
  FROM AHL_UNIT_CONFIG_HEADERS uc1, AHL_UNIT_CONFIG_HEADERS uc2
 WHERE uc1.csi_item_instance_id = p_csi_ii_id1
   AND uc2.csi_item_instance_id = p_csi_ii_id2
   AND uc1.master_config_id = uc2.master_config_id;

Line: 860


SELECT count(distinct unit_of_measure)
  FROM csi_ii_relationships csi_ii,
       csi_item_instances csi
 WHERE csi_ii.object_id = p_csi_instance_id
   AND csi_ii.subject_id = csi.instance_id
   AND csi_ii.position_reference is not null
   AND CSI_II.RELATIONSHIP_TYPE_CODE  = 'COMPONENT-OF'
   AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
   AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 872


SELECT nvl(sum(quantity),0) quantity
  FROM csi_ii_relationships csi_ii,
       csi_item_instances csi
 WHERE csi_ii.object_id = p_csi_instance_id
   AND csi_ii.subject_id = csi.instance_id
   AND csi_ii.position_reference is not null
   AND CSI_II.RELATIONSHIP_TYPE_CODE  = 'COMPONENT-OF'
   AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
   AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);

Line: 884


 SELECT instance_number from csi_item_instances
  WHERE instance_id = p_csi_instance_id;