APPS.WSM_WLT_VALIDATE_PVT dependencies on BOM_BILL_OF_MATERIALS

Line 372: from bom_bill_of_materials bom

368: select bom.bill_sequence_id,
369: bom.common_bill_sequence_id
370: into x_bom_seq_id,
371: p_common_bom_seq_id --x_common_bom_seq_id --VJ: Changed
372: from bom_bill_of_materials bom
373: where bom.alternate_bom_designator is null
374: and bom.assembly_item_id = l_bom_item_id
375: and bom.organization_id = p_org_id;
376: EXCEPTION

Line 408: FROM bom_bill_of_materials bom,

404: SELECT bom.bill_sequence_id,
405: bom.common_bill_sequence_id
406: INTO x_bom_seq_id,
407: p_common_bom_seq_id --x_common_bom_seq_id --VJ: Changed
408: FROM bom_bill_of_materials bom,
409: bom_alternate_designators bad
410: WHERE ((bom.alternate_bom_designator is null and
411: bad.alternate_designator_code is null and
412: bad.organization_id = -1) or

Line 449: FROM bom_bill_of_materials bom

445: SELECT bom.bill_sequence_id,
446: bom.alternate_bom_designator
447: INTO x_bom_seq_id,
448: p_alt_bom
449: FROM bom_bill_of_materials bom
450: WHERE bom.common_bill_sequence_id = p_common_bom_seq_id
451: AND bom.assembly_item_id = l_bom_item_id
452: AND bom.organization_id = p_org_id;
453:

Line 479: FROM bom_bill_of_materials bom

475: l_stmt_num := 60;
476: BEGIN
477: SELECT 1
478: INTO l_temp_num
479: FROM bom_bill_of_materials bom
480: WHERE bom.common_bill_sequence_id = p_common_bom_seq_id
481: AND bom.alternate_bom_designator = p_alt_bom
482: AND bom.assembly_item_id = l_bom_item_id
483: AND bom.organization_id = p_org_id;