APPS.ENG_LAUNCH_ECO_OI_PK dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 425: FROM bom_inventory_comps_interface

421: basis_type ,
422: from_end_item_unit_number, /*Bug 6377841*/
423: to_end_item_unit_number
424: /*Bug 6377841*/
425: FROM bom_inventory_comps_interface
426: WHERE eng_changes_ifce_key = g_ECO_ifce_key
427: AND interface_entity_type = 'ECO'
428: AND process_flag = 1
429: AND (g_all_org = 1

Line 438: FROM bom_inventory_comps_interface

434: -- Group revised comps by ECO Header ifce values
435:
436: CURSOR GetCompWithSameECOifce IS
437: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
438: FROM bom_inventory_comps_interface
439: WHERE process_flag = 1
440: AND (g_all_org = 1
441: OR
442: (g_all_org = 2 AND organization_id = g_org_id));

Line 539: FROM bom_inventory_comps_interface

535: from_end_item_unit_number,
536: /*Bug 6377841*/
537: to_end_item_unit_number
538: /*Bug 6377841*/
539: FROM bom_inventory_comps_interface
540: WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
541: AND interface_entity_type = 'ECO'
542: AND process_flag = 1
543: AND (g_all_org = 1

Line 552: FROM bom_inventory_comps_interface

548: -- Group revised comps by revised item ifce values
549:
550: CURSOR GetCompWithSameItemifce IS
551: SELECT DISTINCT(ENG_REVISED_ITEMS_IFCE_KEY) item_ifce_key
552: FROM bom_inventory_comps_interface
553: WHERE process_flag = 1
554: AND (g_all_org = 1
555: OR
556: (g_all_org = 2 AND organization_id = g_org_id));

Line 652: FROM bom_inventory_comps_interface

648: basis_type ,
649: from_end_item_unit_number, /*Bug 6377841*/
650: to_end_item_unit_number
651: /*Bug 6377841*/
652: FROM bom_inventory_comps_interface
653: WHERE interface_entity_type = 'ECO'
654: AND process_flag = 1
655: AND (g_all_org = 1
656: OR (g_all_org = 2

Line 995: UPDATE bom_inventory_comps_interface

991: UPDATE eng_revised_items_interface
992: SET PROCESS_FLAG = l_process_flag
993: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
994:
995: UPDATE bom_inventory_comps_interface
996: SET PROCESS_FLAG = l_process_flag
997: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
998:
999: UPDATE bom_sub_comps_interface

Line 1197: UPDATE bom_inventory_comps_interface SET

1193: p_rev_comp_tbl BOM_Bo_PUB.Rev_Component_Tbl_Type
1194: ) IS
1195: BEGIN
1196: FOR i IN 1..p_rev_comp_tbl.COUNT LOOP
1197: UPDATE bom_inventory_comps_interface SET
1198: supply_subinventory = p_rev_comp_tbl(i).supply_subinventory,
1199: -- operation_lead_time_percent = p_rev_comp_tbl(i).op_lead_time_percent,
1200: -- revised_item_sequence_id = p_rev_comp_tbl(i).revised_item_sequence_id,
1201: -- cost_factor = p_rev_comp_tbl(i).cost_factor,

Line 3052: UPDATE bom_inventory_comps_interface bici

3048: WHERE mp2.organization_code = erii.organization_code);
3049:
3050:
3051: stmt_num := 6;
3052: UPDATE bom_inventory_comps_interface bici
3053: SET organization_id = (SELECT organization_id
3054: FROM mtl_parameters mp1
3055: WHERE mp1.organization_code = bici.organization_code)
3056: WHERE process_flag = 1

Line 3172: UPDATE bom_inventory_comps_interface

3168: OR
3169: (p_all_org = 2 AND organization_id = p_org_id));
3170:
3171: stmt_num := 10.4;
3172: UPDATE bom_inventory_comps_interface
3173: SET transaction_id = mtl_system_items_interface_s.nextval,
3174: transaction_type = UPPER(transaction_type)
3175: WHERE process_flag = 1
3176: AND (transaction_id is NULL

Line 6141: DELETE from bom_inventory_comps_interface

6137: END LOOP;
6138:
6139: stmt_num := 516;
6140: LOOP
6141: DELETE from bom_inventory_comps_interface
6142: WHERE process_flag = 7
6143: AND rownum < G_ROWS_TO_COMMIT;
6144:
6145: EXIT when SQL%NOTFOUND;