DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on BOM_COMPONENTS_B

Line 3370: FROM bom_components_b

3366: , wip_supply_type, so_basis, basis_type, optional, mutually_exclusive_options
3367: , check_atp, shipping_allowed, required_to_ship, required_for_revenue, include_on_ship_docs
3368: , quantity_related, supply_subinventory, low_quantity, high_quantity, from_end_item_unit_number
3369: , TO_END_ITEM_UNIT_NUMBER, ORIGINAL_SYSTEM_REFERENCE
3370: FROM bom_components_b
3371: WHERE component_sequence_id = p_component_sequence_id
3372: UNION ALL
3373: SELECT component_item_id, supply_locator_id, bill_sequence_id, old_component_sequence_id
3374: , effectivity_date , attribute_category, ACD_TYPE, change_notice, disable_date

Line 4853: FROM bom_components_b bcb

4849: -- given Change Notice
4850:
4851: CURSOR c_plm_rev_comps (cp_revised_item_sequence_id NUMBER) IS
4852: SELECT *
4853: FROM bom_components_b bcb
4854: WHERE change_notice = p_change_notice
4855: AND revised_item_sequence_id = cp_revised_item_sequence_id
4856: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4857: WHERE ecpm.change_id = p_change_id