APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_STRUCTURES_B

Line 2935: FROM BOM_STRUCTURES_B

2931: l_dummy VARCHAR2(1);
2932: BEGIN
2933: SELECT 'Y'
2934: INTO l_dummy
2935: FROM BOM_STRUCTURES_B
2936: WHERE BILL_SEQUENCE_ID = p_bill_sequence_id
2937: AND BILL_SEQUENCE_ID <> SOURCE_BILL_SEQUENCE_ID;
2938: Return true;
2939: EXCEPTION

Line 3027: BOM_STRUCTURES_B BOM_STRUCT

3023: SELECT STRUCTURE_TYPE_NAME
3024: INTO
3025: l_structure_type_name
3026: FROM BOM_STRUCTURE_TYPES_B STRUCT_TYPE,
3027: BOM_STRUCTURES_B BOM_STRUCT
3028: WHERE BOM_STRUCT.STRUCTURE_TYPE_ID = STRUCT_TYPE.STRUCTURE_TYPE_ID
3029: AND BOM_STRUCT.BILL_SEQUENCE_ID = p_bill_sequence_id;
3030:
3031: RETURN l_structure_type_name;

Line 5744: -- BOM_STRUCTURES_B BOM_STRUCT

5740: -- SELECT STRUCTURE_TYPE_NAME
5741: -- INTO
5742: -- l_Structure_Type_Name
5743: -- FROM BOM_STRUCTURE_TYPES_B STRUCT_TYPE,
5744: -- BOM_STRUCTURES_B BOM_STRUCT
5745: -- WHERE BOM_STRUCT.STRUCTURE_TYPE_ID = STRUCT_TYPE.STRUCTURE_TYPE_ID
5746: -- AND BOM_STRUCT.BILL_SEQUENCE_ID = g_Rev_Comp_Unexp_Rec.BILL_SEQUENCE_ID;
5747: l_Structure_Type_Name := Get_Structure_Type_Name(p_bill_sequence_id =>
5748: g_Rev_Comp_Unexp_Rec.BILL_SEQUENCE_ID);