DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_REVISED_COMPONENTS

Line 1843: FROM eng_revised_components

1839: bom_inventory_components table hence this extra cursor. */
1840:
1841: CURSOR c_rev_comps_disable IS
1842: SELECT *
1843: FROM eng_revised_components
1844: WHERE change_notice = p_change_notice
1845: AND ACD_TYPE = 3
1846: AND revised_item_sequence_id in
1847: (SELECT revised_item_sequence_id

Line 3382: , TO_END_ITEM_UNIT_NUMBER, ORIGINAL_SYSTEM_REFERENCE FROM eng_revised_components

3378: , component_quantity, planning_factor, component_yield_factor, include_in_cost_rollup
3379: , wip_supply_type, so_basis, basis_type, optional, mutually_exclusive_options
3380: , check_atp, shipping_allowed, required_to_ship, required_for_revenue, include_on_ship_docs
3381: , quantity_related, supply_subinventory, low_quantity, high_quantity, from_end_item_unit_number
3382: , TO_END_ITEM_UNIT_NUMBER, ORIGINAL_SYSTEM_REFERENCE FROM eng_revised_components
3383: WHERE component_sequence_id = p_component_sequence_id
3384: AND acd_type = 3;
3385:
3386: -- Cursor to Pick all substitute Component Items for the Top Organization for

Line 4833: FROM eng_revised_components erc

4829:
4830: CURSOR c_plm_rev_comps_disable (cp_revised_item_sequence_id NUMBER)
4831: IS
4832: SELECT *
4833: FROM eng_revised_components erc
4834: WHERE erc.change_notice = p_change_notice
4835: AND erc.ACD_TYPE = 3
4836: AND erc.revised_item_sequence_id = cp_revised_item_sequence_id
4837: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm