APPS.ENG_LAUNCH_ECO_OI_PK dependencies on BOM_OP_RESOURCES_INTERFACE

Line 944: FROM bom_op_resources_interface

940: -- Group ECO Revised Resources by ECO Header ifce values
941:
942: CURSOR GetRevResWithSameECOifce IS
943: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
944: FROM bom_op_resources_interface
945: WHERE process_flag = 1
946: AND (g_all_org = 1
947: OR
948: (g_all_org = 2 AND organization_id = g_org_id));

Line 1011: UPDATE bom_op_resources_interface

1007: UPDATE bom_ref_desgs_interface
1008: SET PROCESS_FLAG = l_process_flag
1009: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1010:
1011: UPDATE bom_op_resources_interface
1012: SET PROCESS_FLAG = l_process_flag
1013: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1014:
1015: UPDATE bom_op_sequences_interface

Line 2314: FROM bom_op_resources_interface

2310: attribute12, attribute13, attribute14, attribute15,
2311: original_system_reference, transaction_type, setup_code
2312: -- Bug 3412268: Added New_Revised_Item_Revision
2313: , New_Revised_Item_Revision
2314: FROM bom_op_resources_interface
2315: WHERE eng_changes_ifce_key = g_ECO_ifce_key;
2316: i NUMBER;
2317: BEGIN
2318: i := 0;

Line 3113: UPDATE bom_op_resources_interface bori

3109: FROM mtl_parameters mp2
3110: WHERE mp2.organization_code = bosi.organization_code);
3111:
3112: stmt_num := 8.2;
3113: UPDATE bom_op_resources_interface bori
3114: SET organization_id = (SELECT organization_id
3115: FROM mtl_parameters mp1
3116: WHERE mp1.organization_code = bori.organization_code)
3117: WHERE process_flag = 1

Line 3225: UPDATE bom_op_resources_interface

3221: OR
3222: (p_all_org = 2 AND organization_id = p_org_id));
3223:
3224: stmt_num := 10.8;
3225: UPDATE bom_op_resources_interface
3226: SET transaction_id = mtl_system_items_interface_s.nextval,
3227: transaction_type = UPPER(transaction_type)
3228: WHERE process_flag = 1
3229: AND (transaction_id is NULL

Line 6221: DELETE from bom_op_resources_interface

6217: END LOOP;
6218:
6219: stmt_num := 521;
6220: LOOP
6221: DELETE from bom_op_resources_interface
6222: WHERE process_flag = 7
6223: AND rownum < G_ROWS_TO_COMMIT;
6224:
6225: EXIT when SQL%NOTFOUND;