APPS.INV_STATUS_PKG dependencies on MTL_ITEM_LOCATIONS

Line 56: MTL_ITEM_LOCATIONS_KFV mil

52:
53: select mms.status_code
54: into x_status_code
55: from mtl_material_statuses mms ,
56: MTL_ITEM_LOCATIONS_KFV mil
57: where mms.status_id = mil.status_id
58: and mil.INVENTORY_LOCATION_ID = p_locator_id
59: and mil.organization_id = p_org_id;
60:

Line 365: select mil.rowid FROM mtl_item_locations mil,

361: AND mmsh.status_update_id = p_transaction_id
362: FOR UPDATE NOWAIT;
363:
364: CURSOR cur_Loc IS
365: select mil.rowid FROM mtl_item_locations mil,
366: mtl_material_status_history mmsh
367: where mil.organization_id = mmsh.organization_id
368: and mil.inventory_location_id = mmsh.locator_id
369: AND mmsh.status_update_id = p_transaction_id

Line 486: update mtl_item_locations

482: OPEN cur_Loc;
483: FETCH cur_Loc BULK COLLECT INTO rowid_list ;
484:
485: FORALL j in rowid_list.first .. rowid_list.last
486: update mtl_item_locations
487: set status_id = p_status_id
488: , last_updated_by = FND_GLOBAL.USER_ID
489: , last_update_date = SYSDATE
490: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 849: update mtl_item_locations

845:
846: --ERES Deferred
847:
848: IF p_pending_status = 0 THEN --ERES Deferred
849: update mtl_item_locations
850: set status_id = p_loc_status_id
851: , last_updated_by = FND_GLOBAL.USER_ID
852: , last_update_date = SYSDATE
853: , last_update_login = FND_GLOBAL.LOGIN_ID