APPS.BOM_BO_PUB dependencies on BOM_ALTERNATE_DESIGNATORS

Line 1520: -- fine-grained security policy on bom_alternate_designators

1516: Bom_Globals.Set_Org_Id( p_org_id => l_organization_id);
1517:
1518: --
1519: -- Set Application Id in the appication context and set the
1520: -- fine-grained security policy on bom_alternate_designators
1521: -- table. This is currently applicable only if the application
1522: -- calling this BO is EAM
1523: --
1524: Bom_Set_Context.set_application_id;

Line 1541: bom_alternate_designators alt

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
1545: select decode(enable_unimplemented_boms,'Y',null, sysdate)

Line 1548: bom_alternate_designators alt

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;
1552: END IF;

Line 3551: bom_alternate_designators alt

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:
3555:

Line 3581: bom_alternate_designators alt

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
3585: and stype.structure_type_id = alt.structure_type_id;

Line 3590: bom_alternate_designators alt,

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
3594: and org.organization_code = p_Organization_Code