APPS.BOM_ROLLUP_PUB dependencies on BOM_SMALL_IMPL_TEMP

Line 132: DELETE FROM BOM_SMALL_IMPL_TEMP;

128: is
129: BEGIN
130: --Removed for 11.5.10-E
131: --DELETE FROM BOM_EXPLOSIONS_ALL;
132: DELETE FROM BOM_SMALL_IMPL_TEMP;
133:
134: Error_Handler.Close_Debug_Session;
135: END;
136:

Line 1321: FROM BOM_SMALL_IMPL_TEMP IMPL

1317: SELECT IMPL.PARENT_ITEM_ID ,
1318: IMPL.ORGANIZATION_ID ,
1319: IMPL.ALTERNATE_DESIGNATOR AS PARENT_ALTERNATE_DESIGNATOR ,
1320: IMPL.STRUCTURE_TYPE_ID
1321: FROM BOM_SMALL_IMPL_TEMP IMPL
1322: WHERE IMPL.SEQUENCE_ID = p_sequence_id
1323: AND IMPL.TOP_ITEM_FLAG = 'Y'
1324: AND ( CURRENT_LEVEL = 0
1325: OR EXISTS(

Line 1445: BOM_SMALL_IMPL_TEMP

1441: THEN
1442: SELECT
1443: COUNT(COMPONENT_SEQUENCE_ID) INTO l_parents_for_pk1
1444: from
1445: BOM_SMALL_IMPL_TEMP
1446: WHERE
1447: LOWEST_ITEM_ID = l_rollup_item_id
1448: AND ORGANIZATION_ID = p_organization_id
1449: AND CURRENT_LEVEL > 0

Line 1466: BOM_SMALL_IMPL_TEMP

1462: AND STRUCTURE_TYPE_ID = p_structure_type_id
1463: AND IS_PREFERRED = 'Y';
1464:
1465: UPDATE
1466: BOM_SMALL_IMPL_TEMP
1467: SET
1468: TOP_ITEM_FLAG ='Y',
1469: ALTERNATE_DESIGNATOR = l_alternate_bom_code,
1470: STRUCTURE_TYPE_ID = p_structure_type_id

Line 1482: BOM_SMALL_IMPL_TEMP

1478: WHEN OTHERS THEN
1479: l_alternate_bom_code := NULL;
1480: BEGIN
1481: UPDATE
1482: BOM_SMALL_IMPL_TEMP
1483: SET
1484: TOP_ITEM_FLAG ='Y'
1485: WHERE
1486: CURRENT_LEVEL = 0