DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_REVISED_COMPONENTS

Line 1862: FROM eng_revised_components

1858: bom_inventory_components table hence this extra cursor. */
1859:
1860: CURSOR c_rev_comps_disable IS
1861: SELECT *
1862: FROM eng_revised_components
1863: WHERE change_notice = p_change_notice
1864: AND ACD_TYPE = 3
1865: AND revised_item_sequence_id in
1866: (SELECT revised_item_sequence_id

Line 3507: , TO_END_ITEM_UNIT_NUMBER, ORIGINAL_SYSTEM_REFERENCE FROM eng_revised_components

3503: , component_quantity, planning_factor, component_yield_factor, include_in_cost_rollup
3504: , wip_supply_type, so_basis, basis_type, optional, mutually_exclusive_options
3505: , check_atp, shipping_allowed, required_to_ship, required_for_revenue, include_on_ship_docs
3506: , quantity_related, supply_subinventory, low_quantity, high_quantity, from_end_item_unit_number
3507: , TO_END_ITEM_UNIT_NUMBER, ORIGINAL_SYSTEM_REFERENCE FROM eng_revised_components
3508: WHERE component_sequence_id = p_component_sequence_id
3509: AND acd_type = 3;
3510:
3511: -- Cursor to Pick all substitute Component Items for the Top Organization for

Line 4960: FROM eng_revised_components erc

4956:
4957: CURSOR c_plm_rev_comps_disable (cp_revised_item_sequence_id NUMBER)
4958: IS
4959: SELECT *
4960: FROM eng_revised_components erc
4961: WHERE erc.change_notice = p_change_notice
4962: AND erc.ACD_TYPE = 3
4963: AND erc.revised_item_sequence_id = cp_revised_item_sequence_id
4964: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm