APPS.IBE_CCTBOM_PVT SQL Statements

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

Line: 15

	SELECT component_item_id,optional,bom_item_type	FROM BOM_EXPLOSIONS
	WHERE  top_bill_sequence_id =
	                (SELECT bill_sequence_id FROM bom_structures_b
                         WHERE assembly_item_id = p_model_id
                           AND organization_id = p_organization_id
                           AND alternate_bom_designator IS NULL)
	AND EXPLOSION_TYPE = 'ALL'
	AND organization_id = p_organization_id
	AND plan_level=1
	AND NVL(disable_date,sysdate) >=sysdate
	AND NVL(effectivity_date,sysdate) <= sysdate;

Line: 53

        SELECT count(component_item_id) into l_total_component_items
        FROM BOM_EXPLOSIONS
     	WHERE top_bill_sequence_id =
     	                     (SELECT bill_sequence_id
     	                      FROM bom_structures_b
                              WHERE assembly_item_id = p_model_id
                                AND organization_id = p_organization_id
                                AND alternate_bom_designator IS NULL)
	  AND EXPLOSION_TYPE = 'ALL'
     	  AND plan_level = 2
     	  AND organization_id = p_organization_id
     	  AND component_code like l_component_code
	  AND NVL(disable_date,sysdate) >=sysdate
	  AND NVL(effectivity_date,sysdate) <= sysdate;

Line: 72

            SELECT component_item_id, optional into l_item_id,l_optional
            FROM BOM_EXPLOSIONS
     	    WHERE top_bill_sequence_id =
     	                       (SELECT bill_sequence_id
     	                        FROM bom_structures_b
                                WHERE assembly_item_id = p_model_id
                                  AND organization_id = p_organization_id
                                  AND alternate_bom_designator IS NULL)
     	       AND EXPLOSION_TYPE = 'ALL'
     	       AND plan_level = 2
     	       AND organization_id = p_organization_id
     	       AND component_code like l_component_code
	       AND NVL(disable_date,sysdate) >=sysdate
	       AND NVL(effectivity_date,sysdate) <= sysdate;

Line: 204

      SELECT MSIV.bom_item_type
      FROM mtl_system_items_vl MSIV
      WHERE MSIV.inventory_item_id = p_model_id
        AND MSIV.organization_id = p_organization_id;

Line: 379

  SELECT COMPONENT_ITEM_ID,
         PLAN_LEVEL,
         OPTIONAL,
         PARENT_BOM_ITEM_TYPE,
         BOM_ITEM_TYPE,
         PRIMARY_UOM_CODE,
         COMPONENT_QUANTITY,
         COMPONENT_CODE
  FROM   BOM_EXPLOSIONS
  WHERE  top_bill_sequence_id =
               (SELECT bill_sequence_id FROM bom_structures_b
                WHERE assembly_item_id = p_model_id
                  AND organization_id = p_organization_id
                  AND alternate_bom_designator IS NULL)
  AND    ORGANIZATION_ID = p_organization_id  --gzhang 01/16/2003, bug#2750492
  AND    EXPLOSION_TYPE = 'ALL'
  AND    PARENT_BOM_ITEM_TYPE < 3
  AND    COMPONENT_ITEM_ID <> TOP_ITEM_ID
  --AND    OPTIONAL = 2
  AND    DISABLE_DATE >= sysdate;

Line: 403

   IBE_UTIL.debug(G_PKG_NAME||'.Load_Components: After select in load');