DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1196: l_revised_item_number mtl_system_items_kfv.concatenated_segments%TYPE;

1192:
1193: l_use_up_item_exists NUMBER;
1194: l_item_sourced_flag NUMBER := 2;
1195: l_structure_exists_flag NUMBER;
1196: l_revised_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
1197: l_common_bom_flag NUMBER;
1198: l_local_bill_sequence_id NUMBER;
1199: l_comn_bill_sequence_id NUMBER;
1200: l_eng_bill_flag NUMBER;

Line 3405: FROM mtl_system_items_kfv

3401: AND component_sequence_id = p_component_sequence_id;
3402:
3403: CURSOR c_get_item_details(cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
3404: SELECT concatenated_segments
3405: FROM mtl_system_items_kfv
3406: WHERE inventory_item_id = cp_inventory_item_id
3407: AND organization_id = cp_organization_id;
3408: BEGIN
3409: -- Initialize this API for error handling