DBA Data[Home] [Help]

APPS.BOM_COMPUTE_FUNCTIONS dependencies on BOM_COMPONENTS_B

Line 77: FROM bom_components_b comp

73: ,p_component_sequence_id IN OUT NOCOPY NUMBER)
74: IS
75: CURSOR c_parent_or_leaf IS
76: SELECT 'Parent'
77: FROM bom_components_b comp
78: ,bom_structures_b parent
79: WHERE comp.component_sequence_id = p_component_sequence_id
80: AND comp.bill_sequence_id = parent.bill_sequence_id
81: AND EXISTS (SELECT bill_sequence_id

Line 642: , bom_components_b bic

638: SELECT is_trade_item_a_consumer_unit
639: , customer_order_enabled_flag
640: , Bom_Rollup_Pub.Is_UCCNet_Enabled(bic.component_item_id, p_organization_id) is_uccnet
641: FROM ego_items_v
642: , bom_components_b bic
643: WHERE inventory_item_id = bic.component_item_id
644: AND organization_id = p_organization_id
645: AND bic.component_sequence_id = p_component_sequence_id;
646: