DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_REVISION dependencies on BOM_BILL_OF_MATERIALS

Line 108: FROM bom_bill_of_materials

104: SELECT 1
105: INTO l_dummy
106: FROM SYS.DUAL
107: WHERE EXISTS ( SELECT bill_sequence_id
108: FROM bom_bill_of_materials
109: WHERE assembly_item_id
110: = p_bom_rev_Unexp_Rec.assembly_item_id
111: AND organization_id
112: = p_bom_rev_Unexp_Rec.organization_id

Line 119: FROM bom_bill_of_materials

115:
116: /* Comment out due to an error when the SQL return multiple rec.
117: SELECT bill_sequence_id
118: INTO l_dummy
119: FROM bom_bill_of_materials
120: WHERE assembly_item_id = p_bom_rev_Unexp_Rec.assembly_item_id
121: AND organization_id = p_bom_rev_Unexp_Rec.organization_id;
122: */
123: