DBA Data[Home] [Help]

APPS.BOM_DEFAULT_BOM_COMPONENT dependencies on BOM_BILL_OF_MATERIALS

Line 41: FROM bom_bill_of_materials

37: l_alternate_bom_designator VARCHAR2(10) := NULL;
38:
39: CURSOR GetAlternate IS
40: SELECT alternate_bom_designator
41: FROM bom_bill_of_materials
42: WHERE bill_sequence_id = g_rev_comp_unexp_rec.bill_sequence_id;
43:
44: CURSOR CheckRouting IS
45: SELECT 'x'

Line 471: FROM bom_bill_of_materials bom

467: RETURN NUMBER
468: IS
469: CURSOR c_CheckForNew IS
470: SELECT Bill_Sequence_Id
471: FROM bom_bill_of_materials bom
472: WHERE bom.assembly_item_id =
473: g_Rev_Comp_Unexp_Rec.revised_item_id
474: AND bom.organization_id =
475: g_Rev_Comp_Unexp_Rec.organization_id