DBA Data[Home] [Help]

APPS.BOM_ROLLUP_PUB dependencies on BOM_IMPLOSIONS_V

Line 1297: FROM bom_implosions_v impl

1293: SELECT impl.parent_item_id
1294: , impl.organization_id
1295: , impl.parent_alternate_designator
1296: , structure_type_id
1297: FROM bom_implosions_v impl
1298: where
1299: impl.sequence_id = p_sequence_id
1300: and impl.top_item_flag='Y'
1301: and ( current_level = 0

Line 1573: FROM bom_implosions_v

1569: CURSOR c_Top_Items(p_sequence_id NUMBER)
1570: IS
1571: SELECT parent_item_id
1572: , organization_id
1573: FROM bom_implosions_v
1574: WHERE sequence_id = p_sequence_id
1575: AND top_item_flag = 'Y';
1576:
1577: l_rollup_id NUMBER;