APPS.BOM_BO_PUB dependencies on BOM_STRUCTURE_TYPES_B

Line 1540: from bom_structure_types_b stype,

1536: IF(l_bom_header_rec.alternate_bom_code IS NULL)
1537: THEN
1538: select decode(enable_unimplemented_boms,'Y',null, sysdate)
1539: into l_bom_header_rec.BOM_Implementation_Date
1540: from bom_structure_types_b stype,
1541: bom_alternate_designators alt
1542: where alt.alternate_designator_code IS NULL
1543: and stype.structure_type_id = alt.structure_type_id;
1544: ELSE

Line 1547: from bom_structure_types_b stype,

1543: and stype.structure_type_id = alt.structure_type_id;
1544: ELSE
1545: select decode(enable_unimplemented_boms,'Y',null, sysdate)
1546: into l_bom_header_rec.BOM_Implementation_Date
1547: from bom_structure_types_b stype,
1548: bom_alternate_designators alt
1549: where alt.alternate_designator_code = l_bom_header_rec.alternate_bom_code
1550: and organization_id = l_organization_id
1551: and stype.structure_type_id = alt.structure_type_id;

Line 1562: from bom_structure_types_b stype

1558: IF(l_bom_header_rec.alternate_bom_code IS NULL)
1559: THEN
1560: select decode(enable_unimplemented_boms,'Y',null, sysdate)
1561: into l_bom_header_rec.BOM_Implementation_Date
1562: from bom_structure_types_b stype
1563: where stype.structure_type_name = 'Asset BOM';
1564: ELSE
1565: -- The control should not come here when the alternate is not null. The query above should
1566: -- not throw a no_data_found exception. If it throws, then there is something else which is wrong

Line 3550: from bom_structure_types_b stype,

3546: l_bom_header_rec.alternate_bom_code := null;
3547:
3548: select decode(enable_unimplemented_boms,'Y',null, sysdate)
3549: into l_bom_header_rec.BOM_Implementation_Date
3550: from bom_structure_types_b stype,
3551: bom_alternate_designators alt
3552: where alt.alternate_designator_code IS NULL
3553: and stype.structure_type_id = alt.structure_type_id;
3554:

Line 3580: from bom_structure_types_b stype,

3576:
3577: if (p_Alternate_Bom_Code is NULL) then
3578: select decode(enable_unimplemented_boms,'Y',null, sysdate)
3579: into l_bom_header_rec.BOM_Implementation_Date
3580: from bom_structure_types_b stype,
3581: bom_alternate_designators alt
3582: where
3583: alt.alternate_designator_code is NULL
3584: and alt.organization_id = -1

Line 3589: from bom_structure_types_b stype,

3585: and stype.structure_type_id = alt.structure_type_id;
3586: else
3587: select decode(enable_unimplemented_boms,'Y',null, sysdate)
3588: into l_bom_header_rec.BOM_Implementation_Date
3589: from bom_structure_types_b stype,
3590: bom_alternate_designators alt,
3591: org_organization_definitions org
3592: where alt.alternate_designator_code = p_Alternate_Bom_Code
3593: and alt.organization_id = org.organization_id