DBA Data[Home] [Help]

APPS.BOM_VAL_TO_ID dependencies on BOM_STRUCTURE_TYPES_B

Line 374: l_structure_type_id BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID%TYPE;

370: FUNCTION Structure_Type( p_structure_type_name IN VARCHAR2,
371: x_err_text IN OUT NOCOPY VARCHAR2 )
372: RETURN NUMBER
373: IS
374: l_structure_type_id BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID%TYPE;
375: BEGIN
376: SELECT STRUCTURE_TYPE_ID
377: INTO l_structure_type_id
378: FROM BOM_STRUCTURE_TYPES_B

Line 378: FROM BOM_STRUCTURE_TYPES_B

374: l_structure_type_id BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID%TYPE;
375: BEGIN
376: SELECT STRUCTURE_TYPE_ID
377: INTO l_structure_type_id
378: FROM BOM_STRUCTURE_TYPES_B
379: WHERE STRUCTURE_TYPE_NAME = p_structure_type_name
380: AND ( DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE );
381:
382: RETURN l_structure_type_id;