DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_STRUCTURES_B

Line 2927: FROM BOM_STRUCTURES_B

2923: l_dummy VARCHAR2(1);
2924: BEGIN
2925: SELECT 'Y'
2926: INTO l_dummy
2927: FROM BOM_STRUCTURES_B
2928: WHERE BILL_SEQUENCE_ID = p_bill_sequence_id
2929: AND BILL_SEQUENCE_ID <> SOURCE_BILL_SEQUENCE_ID;
2930: Return true;
2931: EXCEPTION

Line 5509: BOM_STRUCTURES_B BOM_STRUCT

5505: SELECT STRUCTURE_TYPE_NAME
5506: INTO
5507: l_Structure_Type_Name
5508: FROM BOM_STRUCTURE_TYPES_B STRUCT_TYPE,
5509: BOM_STRUCTURES_B BOM_STRUCT
5510: WHERE BOM_STRUCT.STRUCTURE_TYPE_ID = STRUCT_TYPE.STRUCTURE_TYPE_ID
5511: AND BOM_STRUCT.BILL_SEQUENCE_ID = g_Rev_Comp_Unexp_Rec.BILL_SEQUENCE_ID;
5512:
5513: IF (l_Structure_Type_Name ='Packaging Hierarchy') THEN