DBA Data[Home] [Help]

APPS.BOM_DEFAULT_SUB_COMPONENT SQL Statements

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

Line: 57

	SELECT component_quantity
          INTO l_sub_item_quantity
          FROM bom_inventory_components
         WHERE component_sequence_id =
		 p_Sub_Comp_Unexp_Rec.component_sequence_id;
Line: 168

                SELECT meaning INTO l_enforce_int_reqvalue FROM mfg_lookups WHERE
                        lookup_type = 'BOM_ENFORCE_INT_REQUIREMENTS' AND
                        lookup_code = p_enforce_integer;