APPS.ENG_LAUNCH_ECO_OI_PK dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 426: FROM bom_inventory_comps_interface

422: from_end_item_unit_number, /*Bug 6377841*/
423: to_end_item_unit_number
424: /*Bug 6377841*/
425: /*BUG 9374069 revert 8414408,old_from_end_item_unit_number 8414408*/
426: FROM bom_inventory_comps_interface
427: WHERE eng_changes_ifce_key = g_ECO_ifce_key
428: AND interface_entity_type = 'ECO'
429: AND process_flag = 1
430: AND (g_all_org = 1

Line 439: FROM bom_inventory_comps_interface

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

Line 541: FROM bom_inventory_comps_interface

537: /*Bug 6377841*/
538: to_end_item_unit_number
539: /*Bug 6377841*/
540: /*BUG 9374069 revert 8414408,old_from_end_item_unit_number*/
541: FROM bom_inventory_comps_interface
542: WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
543: AND interface_entity_type = 'ECO'
544: AND process_flag = 1
545: AND (g_all_org = 1

Line 554: FROM bom_inventory_comps_interface

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

Line 656: FROM bom_inventory_comps_interface

652: from_end_item_unit_number, /*Bug 6377841*/
653: to_end_item_unit_number
654: /*Bug 6377841*/
655: /*BUG 9374069 revert 8414408,old_from_end_item_unit_number */
656: FROM bom_inventory_comps_interface
657: WHERE interface_entity_type = 'ECO'
658: AND process_flag = 1
659: AND (g_all_org = 1
660: OR (g_all_org = 2

Line 999: UPDATE bom_inventory_comps_interface

995: UPDATE eng_revised_items_interface
996: SET PROCESS_FLAG = l_process_flag
997: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
998:
999: UPDATE bom_inventory_comps_interface
1000: SET PROCESS_FLAG = l_process_flag
1001: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1002:
1003: UPDATE bom_sub_comps_interface

Line 1201: UPDATE bom_inventory_comps_interface SET

1197: p_rev_comp_tbl BOM_Bo_PUB.Rev_Component_Tbl_Type
1198: ) IS
1199: BEGIN
1200: FOR i IN 1..p_rev_comp_tbl.COUNT LOOP
1201: UPDATE bom_inventory_comps_interface SET
1202: supply_subinventory = p_rev_comp_tbl(i).supply_subinventory,
1203: -- operation_lead_time_percent = p_rev_comp_tbl(i).op_lead_time_percent,
1204: -- revised_item_sequence_id = p_rev_comp_tbl(i).revised_item_sequence_id,
1205: -- cost_factor = p_rev_comp_tbl(i).cost_factor,

Line 3058: UPDATE bom_inventory_comps_interface bici

3054: WHERE mp2.organization_code = erii.organization_code);
3055:
3056:
3057: stmt_num := 6;
3058: UPDATE bom_inventory_comps_interface bici
3059: SET organization_id = (SELECT organization_id
3060: FROM mtl_parameters mp1
3061: WHERE mp1.organization_code = bici.organization_code)
3062: WHERE process_flag = 1

Line 3178: UPDATE bom_inventory_comps_interface

3174: OR
3175: (p_all_org = 2 AND organization_id = p_org_id));
3176:
3177: stmt_num := 10.4;
3178: UPDATE bom_inventory_comps_interface
3179: SET transaction_id = mtl_system_items_interface_s.nextval,
3180: transaction_type = UPPER(transaction_type)
3181: WHERE process_flag = 1
3182: AND (transaction_id is NULL

Line 6171: DELETE from bom_inventory_comps_interface

6167: END LOOP;
6168:
6169: stmt_num := 516;
6170: LOOP
6171: DELETE from bom_inventory_comps_interface
6172: WHERE process_flag = 7
6173: AND rownum < G_ROWS_TO_COMMIT;
6174:
6175: EXIT when SQL%NOTFOUND;