DBA Data[Home] [Help]

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 1393: BOM_SMALL_IMPL_TEMP

1389: THEN
1390: SELECT
1391: COUNT(COMPONENT_SEQUENCE_ID) INTO l_parents_for_pk1
1392: from
1393: BOM_SMALL_IMPL_TEMP
1394: WHERE
1395: LOWEST_ITEM_ID = l_rollup_item_id
1396: AND ORGANIZATION_ID = p_organization_id
1397: AND CURRENT_LEVEL > 0

Line 1414: BOM_SMALL_IMPL_TEMP

1410: AND STRUCTURE_TYPE_ID = p_structure_type_id
1411: AND IS_PREFERRED = 'Y';
1412:
1413: UPDATE
1414: BOM_SMALL_IMPL_TEMP
1415: SET
1416: TOP_ITEM_FLAG ='Y',
1417: ALTERNATE_DESIGNATOR = l_alternate_bom_code,
1418: STRUCTURE_TYPE_ID = p_structure_type_id

Line 1430: BOM_SMALL_IMPL_TEMP

1426: WHEN OTHERS THEN
1427: l_alternate_bom_code := NULL;
1428: BEGIN
1429: UPDATE
1430: BOM_SMALL_IMPL_TEMP
1431: SET
1432: TOP_ITEM_FLAG ='Y'
1433: WHERE
1434: CURRENT_LEVEL = 0